Re: How to obtain the maximum value of a date, between 3 tables...

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>, postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to obtain the maximum value of a date, between 3 tables...
Date: 2010-12-09 02:58:49
Message-ID: 1291863529.2571.3.camel@asus-1001PX.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le mercredi 08 décembre 2010 à 13:35 +0000, Andre Lopes a écrit :
> Hi,
>
> Thanks for the reply.
>
> And there are other options to do it without using a UNION? I don't
> need to know from witch table comes the greatest date, but the query
> is complex, this query is part of an UNION. The use of the CASE WHEN
> could be an alternative?
>

SELECT 'tbl1',last_refresh_date FROM tbl1 UNION SELECT 'tbl2',
last_refresh_date FROM tbl2 UNION SELECT 'tbl3', last_refresh_date FROM
tbl3 ORDER BY 1 DESC;

--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service juridique

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2010-12-09 03:03:18 Re: How to obtain the maximum value of a date, between 3 tables...
Previous Message Fujii Masao 2010-12-09 02:58:46 Re: Postgresql 9.1 pg_last_xact_replay_timestamp limitations