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.