FAQ
I have 5 tables like named this:

2009.01
2009.02
2009.03
2009.04
2009.05

Each table has a columns like this:

( id integer,
ts timestamp,
value char(50)
);


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?

TIA

Search Discussions

  • Adam Ruth at May 11, 2009 at 12:37 pm
    You can use union:

    select id, ts, value from 2009.01
    union
    select id, ts, value from 2009.02
    union
    select id, ts, value from 2009.03
    union
    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:

    2009.01
    2009.02
    2009.03
    2009.04
    2009.05

    Each table has a columns like this:

    ( id integer,
    ts timestamp,
    value char(50)
    );


    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?

    TIA

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 11, '09 at 12:17p
activeMay 11, '09 at 12:37p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Adam Ruth: 1 post Mag Gam: 1 post

People

Translate

site design / logo © 2022 Grokbase