Re: is this proper sql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: clayton cottingham <drfrog(at)smartt(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: is this proper sql?
Date: 2001-04-17 20:38:53
Message-ID: 6157.987539933@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

clayton cottingham <drfrog(at)smartt(dot)com> 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 support that (yet).

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Hoffmann 2001-04-17 20:45:16 Re: RTREE on points
Previous Message John Hasler 2001-04-17 20:32:06 Re: function to format floats as money?