Re: PQexecParams and types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PQexecParams and types
Дата
Msg-id 17666.1075819993@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PQexecParams and types  (Czuczy Gergely <phoemix@harmless.hu>)
Ответы Re: PQexecParams and types  (Czuczy Gergely <phoemix@harmless.hu>)
Список pgsql-performance
Czuczy Gergely <phoemix@harmless.hu> writes:
> i've read in the docs to use the proper indexes both types must match in
> the where clause, to achive this the user can simply put a string into the
> side of the equation mark and pgsql will convert it automaticly. my
> question is, when I'm using PQexecParams, should I give all the values as
> a string, and it will be converted, or I have to figure out the type of
> the given field somehow?

You should leave the parameter types unspecified.  Their types will be
resolved in much the same way that a quoted literal is handled.

            regards, tom lane

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

Предыдущее
От: "Rigmor Ukuhe"
Дата:
Сообщение: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Следующее
От: Czuczy Gergely
Дата:
Сообщение: Re: PQexecParams and types