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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
