Determine data type of columns

Поиск
Список
Период
Сортировка
Искать
От
Bryan White
Тема
Determine data type of columns
Дата
Msg-id
012001be0cf0$131ffb60$a3f0f6ce@bryan.arcamax.com
Список
Дерево обсуждения
Determine data type of columns "Bryan White" <bryan@arcamax.com>
Re: [INTERFACES] Determine data type of columns Tom Lane <tgl@sss.pgh.pa.us>
Re: [INTERFACES] Determine data type of columns Herouth Maoz <herouth@oumail.openu.ac.il>
Re: [INTERFACES] Determine data type of columns darcy@druid.net (D'Arcy J.M. Cain)
I have a general purpose utilty for entering data into web based forms.  The
function that parses the data and inserts the record into a table is largely
unaware of the structure of the table it is operating on.  I am currenly
having problems with integer fields.  If I blindly quote all fields the back
end will complain about casting on integer fields.  Also I would like to do
some primitive field validation based on type before submitting to the back
end.

This brings me to my question.  The PQftype function returns an OID but I
don't see any documentation on how to interpret it.  Are the values constant
for the built in types (specifically int4, text, and date)?
Do I have to execute another query to determine the actual type?
Is there a way to encode the values in an insert/update statement such that
they will be quietly converted to the proper type on the backend?

I am using 6.3.2 but will be upgrading to 6.4 shortly.  Will that make this
any easier?

Bryan White
ArcaMax Inc.
Yorktown VA
www.arcamax.com

В списке pgsql-interfaces по дате отправления
От: Byron Nikolaidis
Дата:
Сообщение: NEW ODBC DRIVER v06.40.0001
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
FAQ