Re: default values

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(at)ritterdosreis(dot)br
> Cel.: (51)91287530
> Linux Counter #281893
>
> Faculdade Ritter dos Reis
> www.ritterdosreis.br
> felipes(at)ritterdosreis(dot)br
> Fone/Fax.: (51)32303328
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Dror Matalon
Zapatec Inc
1700 MLK Way
Berkeley, CA 94709
http://www.zapatec.com