Re: [INTERFACES] where did that date and time come from??

On Mon, 19 Apr 1999, JT Kirkpatrick wrote:

> Whoa baby, I lied through my teeth! Inserting DID NOT work fine when done
> in psql on the server itself - it also returned the april 14 date and time
> as default. So I tested around a bit. I redefined a new test table using
> default now() and guess what - it works!!!!! But the documentation says
> that I can define fields as default 'now'. doesn't seem to work right as
> far as I can tell, but defining them as default now() does. . .

I'm just guessing here, but I think I saw somewhere in the Postgres dox
that said if something weren't declared correctly, that it would be
interpreted as a constant and not a function call. If my memory serves
me, this would mean that SQL was actually parsed as default 'apr 14,
10am.' Could be wrong. I've done a lot of reading recently, and, for all
I know, that could be an Oracle quirk. :P

Caveat emptor...

--
Jason Lee | for all my labors and best laid plans I'd only earned
www.screech.org | a reprimand, forevermore to understand that dreams come
screech(at)screech(dot)org | true can kill a man if never graced by sovereign hands