issuing insert preparedstatement queries with default values

Поиск
Список
Период
Сортировка
От Johnny Luong
Тема issuing insert preparedstatement queries with default values
Дата
Msg-id 4B47C7E9.4030000@trustcommerce.com
обсуждение исходный текст
Ответы Re: issuing insert preparedstatement queries with default values  (dmp <danap@ttc-cmc.net>)
Список 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-----

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "John T. Dow"
Дата:
Сообщение: Optimistic locking with multiple rows
Следующее
От: dmp
Дата:
Сообщение: Re: issuing insert preparedstatement queries with default values