Re: order of adding date & interval values?

Поиск
Список
Период
Сортировка
От Lev Lvovsky
Тема Re: order of adding date & interval values?
Дата
Msg-id Pine.BSF.4.21.0205022009120.87204-100000@renegade.pfksound.com
обсуждение исходный текст
Ответ на Re: order of adding date & interval values?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Good lord!  a helpful mailing list!

Wow, thanks for all the help!

-lev (with more questions soon to come!)

On Thu, 2 May 2002, Tom Lane wrote:

> Lev Lvovsky <lists1@sonous.com> writes:
> > is there any reason why the order of operations of the following query
> > would matter?
>
> Perusing the list of operators shown by "\do +" reveals that there's
> a date + interval operator, but no interval + date operator.  So your
> interval + date example is getting interpreted in some surprising
> fashion involving an implicit cast.
[snip]


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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: order of adding date & interval values?
Следующее
От: Paul M Foster
Дата:
Сообщение: Re: Fwd: Postfix Relay Hub SMTP server: errors from postgresql.org[64.49.215.8]