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

Lorenzo Thurman wrote:
> 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

I think I have it, but if anyone has any comments, I'd appreciate it:

select min(old) as oldest from (select distinct min(create) as old from tab1
UNION
select distinct min(time_now) as old from tab1
UNION
select distinct min(create_time) as old from tab2)