Re: Odd optimiser behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Odd optimiser behaviour
Date: 2002-12-01 05:07:32
Message-ID: 15658.1038719252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nicolai Tufar 2002-12-01 05:09:56 Re: Segmentation fault while COPY in 7.3
Previous Message Tom Lane 2002-12-01 05:03:05 Re: 7.4 To Do