Re: default values - Mailing list pgsql-jdbc
From | Dave Cramer |
---|---|
Subject | Re: default values |
Date | |
Msg-id | 1037588879.2185.32.camel@inspiron.cramers Whole thread Raw |
In response to | Re: default values (Dror Matalon <dror@zapatec.com>) |
Responses |
Re: default values
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: default values (Felipe Schnack <felipes@ritterdosreis.br>) |
List | pgsql-jdbc |
1) Yes, it does happen automatically, and to invoke it when it is in the insert statement, just use setNull Dave On Sun, 2002-11-17 at 21:06, Dror Matalon wrote: > Two ideas: > > 1. If you don't include the variable in your insert statement, doesn't > the default value happen automatically? In this case > INSERT INTO TEST (varcharfield1) VALUES (?), should result in > varcharfield2 getting its default value. > > 2. This is a longer shot ... > > does this work? > > INSERT INTO TEST (varcharfield1, varcharfield2) VALUES (?, DEFAULT) > > > Dror > > > > On Sun, Nov 17, 2002 at 09:30:15PM -0100, Felipe Schnack wrote: > > This is the third time I post this message. Nobody have ANY opinion about > > it? I mean, I'm willing to implement a solution for this, but I would like to > > discuss a little... > > Someone wrote to pgsql general list telling that you could insert the > > default value of a column using DEFAULT keyword on pgsql 7.3. Example: > > INSERT INTO TEST (varcharfield1, varcharfield2) VALUES ('text', DEFAULT) > > In this case, the "varcharfield2" column would get its default value (as > > defined in CREATE TABLE). I was wondering, how I would do it using > > PreparedStatements? If I prepare an SQL like > > INSERT INTO TEST (varcharfield1, varcharfield2) VALUES (?, ?) > > I need to have some way to set one of the the parameters as DEFAULT, but > > how? Using the current JDBC driver I believe is impossible, probably we would > > need something like a "setDefault(int)" method in PreparedStatement, where int > > is the parameter index. What do you think about it? > > > > Felipe Schnack > > Analista de Sistemas > > felipes@ritterdosreis.br > > Cel.: (51)91287530 > > Linux Counter #281893 > > > > Faculdade Ritter dos Reis > > www.ritterdosreis.br > > felipes@ritterdosreis.br > > Fone/Fax.: (51)32303328 > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org -- Dave Cramer <Dave@micro-automation.net>
pgsql-jdbc by date: