pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Sawtell <csawtell@xtra.co.nz>
To: Diehl, Jeffrey <jdiehl@sandia.gov>
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
Cc: Diehl, Jeffrey <jdiehl@sandia.gov>
Subject: Re: [SQL] Query from multiple tables...
Date: Wed, 17 Jan 2001 11:41:51 +1300
Message-ID: <01011711415100.09521@berty> (raw)
In-Reply-To: <B51F0C636E578A4E832D3958690CD73E0130BD9B@es04snlnt>
References: <B51F0C636E578A4E832D3958690CD73E0130BD9B@es04snlnt>

On Wed, 17 Jan 2001 09:46, Diehl, Jeffrey wrote:
> 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. 

postgreSQL will manage absolutely huge tables without problems.
( 2GB, & 4GB with that file size setting in the kernel )
Why do you have to cut the data into smaller tables?

> 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?

No problem, if you leave the data in one table.

> 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?

you can issue queries direct from the shell script which would allow you to
use shell variables to hold the date datum.


-- 
Sincerely etc.,

 NAME       Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN    45863470
 EMAIL      csawtell @ xtra . co . nz
 CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--




view thread (3+ messages)  latest in thread

Message-ID: <01011711415100.09521@berty>
Permalink:  ../01011711415100.09521@berty/
Also on:    postgresql.org/message-id/01011711415100.09521@berty

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: csawtell@xtra.co.nz, jdiehl@sandia.gov, pgsql-general@postgresql.org
  Subject: Re: [SQL] Query from multiple tables...
  In-Reply-To: <01011711415100.09521@berty>
  References: <B51F0C636E578A4E832D3958690CD73E0130BD9B@es04snlnt> <01011711415100.09521@berty>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox