Querying from two tables as if they were appended

Поиск
Список
Период
Сортировка
От David Gaudine
Тема Querying from two tables as if they were appended
Дата
Msg-id 446B44BF.4080109@alcor.concordia.ca
обсуждение исходный текст
Ответы Re: Querying from two tables as if they were appended  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-novice
I have two tables with an identical layout.  The difference is that one
has data from this year and one has data from last year.  For a
simplified example let's call them "table05" and "table06", and say that
each has a single column called "name".  So we have

table05:
     David
     Bob

table06:
     David
     John
     Paul

I want to select all rows from both tables, so the result (order not
important) is
     David
     Bob
     David
     John
     Paul

This is surely trivial, but I read the section about joined tables and
it shows only how to give a result that has 2 columns, like

test=# select * from table05,table06;
 name  | name
-------+-------
 David | David
 David | John
 David | Paul
 Bob   | David
 Bob   | John
 Bob   | Paul

One solution would to to create a third table and copy the first two
into it, but since the two tables change frequently this is
undesirable.  How can I do it by querying the existing tables?

Note:  This example is oversimplified.  The real query will also test
other columns, like for example
    select * from ( however I do the above) where age > 25
so the number of rows in the result will not be the sum of the number of
rows in each table.

David


В списке pgsql-novice по дате отправления:

Предыдущее
От: Q Beukes
Дата:
Сообщение: OIDS
Следующее
От: "Dhruv Matani"
Дата:
Сообщение: Where to get more info. about the optimizer?