| From: | Lev Lvovsky <lists1(at)sonous(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: order of adding date & interval values? |
| Date: | 2002-05-03 03:10:37 |
| Message-ID: | Pine.BSF.4.21.0205022009120.87204-100000@renegade.pfksound.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sonous(dot)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]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul M Foster | 2002-05-03 03:16:03 | Re: Fwd: Postfix Relay Hub SMTP server: errors from postgresql.org[64.49.215.8] |
| Previous Message | Thomas Lockhart | 2002-05-03 02:41:23 | Re: order of adding date & interval values? |