From: | "Felipe Schnack" <felipes(at)ritterdosreis(dot)br> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | REPOST: inserting default values |
Date: | 2002-11-16 14:33:49 |
Message-ID: | 20021116133349.M88197@ritterdosreis.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Someone wrote to pgsql general list telling that you could insert the
default value of a column using DEFAULT keyword on pgsql 7.3. Like
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? We should have something like an "setDefault(int)" method
or something? I guess we could do it on JdbcAbstractResultSet, as we do with
SetServerSidePrepare... Just thinking.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Krake | 2002-11-16 14:51:40 | why not type casting by default in prepared statements? |
Previous Message | Marko Štrukelj | 2002-11-16 12:20:00 | jdbc bug/feature? |