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