Re: order of adding date & interval values? - Mailing list pgsql-general

From Lev Lvovsky
Subject Re: order of adding date & interval values?
Date
Msg-id Pine.BSF.4.21.0205022009120.87204-100000@renegade.pfksound.com
Whole thread Raw
In response to Re: order of adding date & interval values?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: order of adding date & interval values?
Next
From: Paul M Foster
Date:
Subject: Re: Fwd: Postfix Relay Hub SMTP server: errors from postgresql.org[64.49.215.8]