From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | clayton cottingham <drfrog(at)smartt(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: is this proper sql? |
Date: | 2001-04-17 20:29:21 |
Message-ID: | Pine.BSF.4.21.0104171326040.78170-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Tue, 17 Apr 2001, clayton cottingham wrote:
> hi one of the developers here at work say this should work
> insert into detail (det_id,det_mas_id,det_date,det_amt) values
> (0,0,now(),'0'), (1,1,now(),'1');
>
>
>
> but when i try that in postgres like:
> insert into detail (det_id,det_mas_id,det_date,det_amt) values
> (0,0,datetime'now','0'), (1,1,datetime'now','1');
>
> i get
> ERROR: parser: parse error at or near ","
>
>
> now i personally dont think this is real sql
> anyone?
I'm pretty sure that meets spec, but isn't currently supported by
postgres. I believe if I'm reading the spec correctly, it's only
required for the highest level of complience.
From | Date | Subject | |
---|---|---|---|
Next Message | John Hasler | 2001-04-17 20:32:06 | Re: function to format floats as money? |
Previous Message | David Olbersen | 2001-04-17 20:29:05 | Re: is this proper sql? |