Postgres Pro
Downloads
Home   >   mailing lists

Re: NEWBIE: How do I get the oldest date contained in 3 tables - Mailing list pgsql-general

From Dann Corbit
Subject Re: NEWBIE: How do I get the oldest date contained in 3 tables
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547010005BD@postal.corporate.connx.com
Whole thread Raw
In response to NEWBIE: How do I get the oldest date contained in 3 tables  (Lorenzo Thurman <lorenzo@diespammerhethurmans.com>)
Responses Re: NEWBIE: How do I get the oldest date contained in 3 tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Just do a union and return the min

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Lorenzo Thurman
> Sent: Monday, April 09, 2007 7:32 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] NEWBIE: How do I get the oldest date contained in 3
> tables
>
> I have three tables using date fields. I want to retrieve the oldest
> date contained in the tables. Can someone show me an example of a
query
> that would do that?
> TIA
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: explain analyze is your friend

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Problem with copying data
Next
From: Bill Moran
Date:
Subject: Re: Is there a shortage of postgresql skilled ops people