On Feb 2, 2012, at 0:16, tiplip <chengwe...@gmail.com> wrote:

> Hi all,
> 
> I have a couple of tables with same structure but standing for different
> layers(1,2,3...) respectivle for Mapserver,
> 
> table1
>        gid    |  id    | name      | address        | post code  | layer   
> |  geom
> -----------+------+----------+-------------+-----------+--------+------------
>        1          1       'name11'      'address11'          102356       1   
>    
> geom11
>        2          2       'name12'      'address12'          102356       1   
>    
> geom12
>        -          -        'name1-'      'address1-'          102356      
> 1       geom1-
> 
> table2
>        gid    |  id    | name      | address        | post code  | layer   
> |  geom
> -----------+------+----------+-------------+-----------+--------+------------
>        1          1       'name21'     'address21'          102356       2    
>   
> geom21
>        2          2       'name22'     'address22'          102356       2    
>   
> geom22
>        -          -        'name2-'     'address2-'          102356       2   
>    
> geom2-
> 
> 
> table3
>        gid    |  id    | name      | address        | post code  | layer   
> |  geom
> -----------+------+----------+-------------+-----------+--------+------------
>        1          1       'name31'      'address31'          102356       3   
>    
> geom31
>        2          2       'name32'      'address32'          102356       3   
>    
> geom32
>        -          -        'name3-'      'address3-'          102356      
> 3       geom3-
> 
> 
> I want to get query results from table1, 2, 3... if key word matches, say
> name like 'name' as follows:
> 
> input 'name', results will be like
> 
> table2
>        gid    |  id    | name      | address        | post code  | layer    
> |  geom
> -----------+------+----------+-------------+-----------+---------+------------
>        1          1       'name11'      'address11'          102356       1   
>    
> geom11
>        2          2       'name12'      'address12'          102356       1   
>    
> geom12
>        3          3       'name21'     'address21'          102356       2    
>   
> geom21
>        4          4       'name22'     'address22'          102356       2    
>   
> geom22
>        5          5       'name31'      'address31'          102356       3   
>    
> geom31
>        6          6       'name32'      'address32'          102356       3   
>    
> geom32
>        -          -       ---------      ---------           -------      -   
>        
> -
> 
> 
> can I achieve that results with a single query sentence? and how?
> any good ideas will be appricated?
> 
> thanks
> 
> 

The general method is to use "UNION" but not sure about the changing of the gid 
and id values...

David J.
-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to