Re: Fwd: Re: [GENERAL] timestamp/function question

2001-03-29 Thread will trillich

On Wed, Mar 28, 2001 at 11:46:42PM -0800, Soma Interesting wrote:
> 
> >blah blah blah 
> >
> >...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?

[EMAIL PROTECTED]
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Fwd: Re: [GENERAL] timestamp/function question

2001-03-28 Thread Soma Interesting


>blah blah blah 
>
>...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!


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl