hi one of the developers here at work say this should workinsert 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?