On Fri, Sep 16, 2005 at 10:18:19AM -0700, Bill Moseley wrote: > On Fri, Sep 16, 2005 at 10:02:28AM -0500, Thomas O'Connell wrote: > > For older versions of postgres, it's recommended that you determine > > the time in the client and use constant data in your query. > > Interesting. I have a few VIEWs that include now(), but I guess I > could adjust and pass in the date from the client. I sometimes use the constant 'now' instead, since it obviously isn't mutable. It's a bit tricky because sometimes it expands when you define the statement. You have to do 'now'::text usually and even then you should check... -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
pgpQfaP7gsZQg.pgp
Description: PGP signature
