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