Re: [HACKERS] empty/automatic insert availability

Thomas Lockhart <lockhart@alumni.caltech.edu>

From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Daniel Péder <dpeder@infoset.cz>
Cc: "'pgsql-hackers@postgresql.org'" <pgsql-hackers@postgreSQL.org>
Date: 1999-10-15T04:55:54Z
Lists: pgsql-hackers
> 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