Just do a union and return the min > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] 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
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
