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?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to