Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

postgres-lambda-diff

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    Bruce Momjian authored
       now. Here some tested features, (examples included in the patch):
    
    1.1) Subselects in the having clause 1.2) Double nested subselects
    1.3) Subselects used in the where clause and in the having clause
         simultaneously 1.4) Union Selects using having 1.5) Indexes
    on the base relations are used correctly 1.6) Unallowed Queries
    are prevented (e.g. qualifications in the
         having clause that belong to the where clause) 1.7) Insert
    into as select
    
    2) Queries using the having clause on view relations also work
       but there are some restrictions:
    
    2.1) Create View as Select ... Having ...; using base tables in
    the select 2.1.1) The Query rewrite system:
    
    2.1.2) Why are only simple queries allowed against a view from 2.1)
    ? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug
    in ExecMergeJoin ??
    
    
    Regards Stefan
    460b20a4
    History
    Name Last commit Last update