From: | Johnny Luong <johnny(dot)luong(at)trustcommerce(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | issuing insert preparedstatement queries with default values |
Date: | 2010-01-09 00:03:53 |
Message-ID: | 4B47C7E9.4030000@trustcommerce.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Is there a way to use the DEFAULT per column value on an INSERT sql in
PG through the PreparedStatement JDBC API? It'd be nice so that I don't
have to maintain a secondary list of PreparedStatements or a list of
default values maintained outside of the database definition.
e.g:
INSERT INTO foo (a, b) (?, ?)
where b has a default value in the database and a is something that I
might set to some other value.
I'm using postgresql-8.3-603.jdbc4.jar against a 8.3 postgresql server.
Thanks,
Johnny
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAktHx+kACgkQnQTBLXttTeVEmgCePgPqSGOtZvii/nGWEVaGeF+l
VX4An0LVEB9Rhlsc0s8j91oTwLOoKS4L
=s1Fo
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | dmp | 2010-01-09 02:15:01 | Re: issuing insert preparedstatement queries with default values |
Previous Message | John T. Dow | 2010-01-02 20:22:07 | Optimistic locking with multiple rows |