|| at May 11, 2009 at 12:37 pm
You can use union:
select id, ts, value from 2009.01
select id, ts, value from 2009.02
select id, ts, value from 2009.03
select id, ts, value from 2009.04
On 11/05/2009, at 10:11 PM, Mag Gam wrote:
I have 5 tables like named this:
Each table has a columns like this:
( id integer,
If I would like to search from 2009.01 to 2009.04 is it possible to
build a query like that? I was thinking if there is a clever VIEW I
can create that would include all 5 tables as 1 table.
Any thoughts or ideas?
Sent via pgsql-novice mailing list (email@example.com)
To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-novice