Re: Odd optimiser behaviour - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Odd optimiser behaviour
Date
Msg-id 15658.1038719252@sss.pgh.pa.us
Whole thread Raw
In response to Odd optimiser behaviour  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Why does using CURRENT_DATE instead of a literal date make a difference?

In 7.3 it doesn't.  Prior versions do not understand that CURRENT_DATE
can be treated like a constant in this context.  Time to update ;-)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4 To Do
Next
From: "Nicolai Tufar"
Date:
Subject: Re: Hard-coded PUBLIC in pg_dump