Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: OT: Postgres, now(), and bindvars

by EvanCarroll (Chaplain)
on Dec 04, 2005 at 21:53 UTC ( [id://513999]=note: print w/replies, xml ) Need Help??


in reply to OT: Postgres, now(), and bindvars

Two things to keep in the back of your mind:

  • Postgres allows functions to be used as defaults, such as CURRENT_TIMESTAMP, and CURRENT_DATE.
  • There is more than one way to cast something, cast('3 minutes' AS interval) and possibly even the old 7.x way of type(var) so interval('3 minutes'), though that should be discouraged.


Evan Carroll
www.EvanCarroll.com

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://513999]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (7)
As of 2024-03-28 12:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found