Re: NEWBIE: How do I get the oldest date contained in 3 tables

Поиск
Список
Период
Сортировка
От Dann Corbit
Тема Re: NEWBIE: How do I get the oldest date contained in 3 tables
Дата
Msg-id D425483C2C5C9F49B5B7A41F89441547010005BD@postal.corporate.connx.com
обсуждение исходный текст
Ответ на NEWBIE: How do I get the oldest date contained in 3 tables  (Lorenzo Thurman <lorenzo@diespammerhethurmans.com>)
Ответы Re: NEWBIE: How do I get the oldest date contained in 3 tables
Список pgsql-general
Just do a union and return the min

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem with copying data
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Is there a shortage of postgresql skilled ops people