is this proper sql?

From: clayton cottingham <drfrog(at)smartt(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: is this proper sql?
Date: 2001-04-17 19:51:16
Message-ID: 3ADC9EB4.C8E80451@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2001-04-17 19:51:52 Re: RTREE on points
Previous Message John Hasler 2001-04-17 18:52:16 Re: function to format floats as money?