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'),
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
On Tue, 17 Apr 2001, clayton cottingham wrote:
now i personally dont think this is real sql
anyone?
Nope, not real. Although that type of syntax would be handy IMHO.
-- Dave
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
clayton cottingham [EMAIL PROTECTED] writes:
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');
Multiple rows in INSERT ... VALUES are legal according to the SQL92
spec, but we don't
clayton cottingham writes:
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');
This is real SQL (except for the now() function) but it isn't supported in
PostgreSQL yet.
--
Peter