Postgres Pro
Downloads
Home   >   mailing lists

Re: On using "date 'XXX' + interval 'XXX'" vs "date 'XXX'" - Mailing list pgsql-general

From Jon Lapham
Subject Re: On using "date 'XXX' + interval 'XXX'" vs "date 'XXX'"
Date
Msg-id 3CE91A55.5030108@extracta.com.br
Whole thread Raw
In response to On using "date 'XXX' + interval 'XXX'" vs "date 'XXX'"  (Jon Lapham <lapham@extracta.com.br>)
List pgsql-general
Tree view 
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@extracta.com.br      web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------

pgsql-general by date:

Previous
From: Denis Perchine
Date:
Subject: Re: PostgreSQL 7.1 forces sequence scan when there is no reason
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL 7.1 forces sequence scan when there is no reason