Query from multiple tables... - Mailing list pgsql-sql

From Diehl, Jeffrey
Subject Query from multiple tables...
Date
Msg-id B51F0C636E578A4E832D3958690CD73E0130BD9B@es04snlnt
Whole thread Raw
Responses Re: Query from multiple tables...  (Christopher Sawtell <csawtell@xtra.co.nz>)
List pgsql-sql
Hi all,

I have a database, that because of the size of the data, I have separated on
day's worth of data into it's own table.  I have a separate table for each
of, say, 30 days.  I would like to write a query that will query the last 15
days worth of tables.  Can this be done?

I tried to use a view; that didn't work.  I tried to use the union clause;
that didn't allow me to do group by...

Is there a better way than to have my program rewrite the sql on the fly?

Thanx, in advance,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl@sandia.gov



pgsql-sql by date:

Previous
From: "Sharmad Naik"
Date:
Subject: python+postgresql
Next
From: Josh Berkus
Date:
Subject: Re: Three questions regarding PL/PGSQL