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

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: How to obtain the maximum value of a date, between 3 tables...
Date: 2010-12-08 13:15:41
Message-ID: AANLkTi=HB8OWbBe-gtn3L4HaNMPeuWoEpnH=UkQ-j_6+@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to obtain the maximum value of a date, but that comparison will be
made between 3 tables... I will explain better with a query...

[code]
select
a.last_refresh_date as d1, ae.last_refresh_date as d2, ha.last_refresh_date
as d3
from tbl1 a
join tbl2 ae on a.id_anuncio_externo = ae.id_anuncio_externo
join tbl3 ha on a.id_anuncio_externo = ha.id_anuncio_externo
[/code]

My question is how is the best way to obtain with date is the greatest, d1,
d2 or d3

Can you guys give me a clue.

Best Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Massa, Harald Armin 2010-12-08 13:18:56 Re: Using PG with Windows EFS or TrueCrypt for encryption
Previous Message Dmitriy Igrishin 2010-12-08 11:55:05 OID of type by name.