Thread

1. empty/automatic insert availability

   Daniel Péder <dpeder@infoset.cz> — 1999-10-12T19:31:24Z

   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
   
   
   

2. Re: [HACKERS] empty/automatic insert availability

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 1999-10-15T04:55:54Z

   > 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