Skip site navigation (1) Skip section navigation (2)

Range queries with multiple tables

From: Mag Gam <magawake(at)gmail(dot)com>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Range queries with multiple tables
Date: 2009-05-11 12:11:48
Message-ID: 1cbd6f830905110511m5b98d93et528f9b72a5b997c2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Adam RuthDate: 2009-05-11 12:36:49
Subject: Re: Range queries with multiple tables
Previous:From: Devrim GÜNDÜZDate: 2009-05-11 10:49:46
Subject: Re: Postfix with PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group