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 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

Re: [GENERAL] timestamp/function question

2001-03-29 Thread Tom Lane
Soma Interesting [EMAIL PROTECTED] writes: Why does the following code return the exact same value each time, instead of a value based on the current time? CREATE FUNCTION memb_num () RETURNS INT4 AS ' BEGIN RETURN date_part(''epoch'', CURRENT_DATE); END; '

Re: [GENERAL] timestamp/function question

2001-03-28 Thread Soma Interesting
At 12:41 AM 3/29/2001 -0600, you wrote: do. In the case of logfunc1(), the Postgres main parser knows when preparing the plan for the INSERT, that the string 'now' should be interpreted as datetime because the target field of logtable is of that type. Thus, it will make a constant from it at this

Fwd: Re: [GENERAL] timestamp/function question

2001-03-28 Thread Soma Interesting
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