Re: On using "date 'XXX' + interval 'XXX'" vs "date 'XXX'"

From: Jon Lapham <lapham(at)extracta(dot)com(dot)br>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: On using "date 'XXX' + interval 'XXX'" vs "date 'XXX'"
Date: 2002-05-20 15:46:29
Message-ID: 3CE91A55.5030108@extracta.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Try coercing the sum result back to a date.

Yup, that does the trick.

As usual, thanks Tom.

-Jon

PS: Is this optimizable? (ie: have the coersion be implicit in
situations like this). It sure seems like it is a good candidate...

--

-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-20 15:54:07 Re: PostgreSQL 7.1 forces sequence scan when there is no reason
Previous Message Denis Perchine 2002-05-20 15:28:22 Re: PostgreSQL 7.1 forces sequence scan when there is no reason