[QGIS-trac] Re: [Quantum GIS] #1790: PostGIS query: allow JOINs

[Quantum GIS]

#1790: PostGIS query: allow JOINs
-------------------------------------+--------------------------------------
        Reporter:  pcav              |         Owner:  nobody       
            Type:  enhancement       |        Status:  closed       
        Priority:  minor: annoyance  |     Milestone:  Version 1.2.0
       Component:  Data Provider     |       Version:  HEAD         
      Resolution:  duplicate         |      Keywords:               
Platform_version:                    |      Platform:  All          
        Must_fix:  No                |   Status_info:  0            
-------------------------------------+--------------------------------------
Changes (by jef):

  * status:  new => closed
  * resolution:  => duplicate

Comment:

 the query builder is just meant to create the where clause to filter on an
 existing table.  That doesn't alter the set of attributes the layer has.
 Doing that would also require changes elsewhere (in that sense it's a
 duplicate of #121).

 For now joins can be done using
 [http://www.postgresql.org/docs/current/interactive/sql-createview.html
 views] or - if it's just to filter the original table using information
 from other tables - using
 [http://www.postgresql.org/docs/current/interactive/functions-
 subquery.html subquery expressions]

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1790#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats