Just do a union and return the min
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Lorenzo Thurman
> Sent: Monday, April 09, 2007 7:32 AM
> To: pgsql-general(at)postgresql(dot)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