Re: Fwd: Re: timestamp/function question - Mailing list pgsql-general

From will trillich
Subject Re: Fwd: Re: timestamp/function question
Date
Msg-id 20010329093335.A24129@mail.serensoft.com
Whole thread Raw
In response to Fwd: Re: timestamp/function question  (Soma Interesting <dfunct@telus.net>)
List pgsql-general
On Wed, Mar 28, 2001 at 11:46:42PM -0800, Soma Interesting wrote:
>
> >blah blah blah <snip>
> >
> >...and that all meant what? The postgres manual is open to much
> >interpretation to anyone new trying to understand its contents. Combine
> >that with documentation that's still not written, or broken across several
> >different sections (programmer, user, admin, etc) and a search engine
> >which returns absolute crap.... well I guess us new users can just go use
> >MySQL.
> >
> >as far as I can tell the above sounds like a complicated  work-around to a
> >bug, but maybe you'll be kind enough to correct me on this...?
>
> BETTER YET!
>
> edit my example code so it works and post it to this list so everyone else
> can have a function that uses ''now'' as actually "this very moment in
> time", rather than "the moment the main parser made 'now' a constant".
>
> Yeesh!

try

    \df time

and see what's available. notably,

    select timeofday(),timenow();

--
does a brain cell think?

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: "Paolo Sinigaglia"
Date:
Subject: VARCHAR and TEXT
Next
From: "chris markiewicz"
Date:
Subject: ExecSQL NullPtrEx...conn timeout?