it would be good idea to enable "empty automatic insert" like this:

mydb => create table pgx_replid ( repltime time DEFAULT current_time );
mydb => insert into pgx_replid;

====
the above should insert the value of current_time into database pgx_replid, however it is impossible yet (ver.6.3.x / 6.5.2). Now, everytime needed, one should type more complex lines like:

mydb => insert into pgx_replid values ( current_time );

====
in case the table was created without any DEFAULT the empty insert should insert NULL or NULLs into all (or specified) fields of table as the general behavior.

--
dan peder
dpeder@infoset.cz


Tue, 12 Oct 1999 20:31:24 +0100
=?iso-8859-2?Q?Daniel_P=E9der?= <dpeder@infoset.cz>
empty/automatic insert availability
> it would be good idea to enable "empty automatic insert" like this:
> mydb => create table pgx_replid ( repltime time DEFAULT current_time );
> mydb => insert into pgx_replid;
> the above should insert the value of current_time into database pgx_replid, however it is 
> impossible yet (ver.6.3.x / 6.5.2).

Not true :)

We support the SQL92-standard syntax:

  mydb => insert into pgx_replid default values;

Have fun with it...

                - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Fri, 15 Oct 1999 04:55:54 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] empty/automatic insert availability