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>
