PQexecParams and types

Поиск
Список
Период
Сортировка
От Czuczy Gergely
Тема PQexecParams and types
Дата
Msg-id Pine.LNX.4.44.0402030822001.19142-100000@localhost
обсуждение исходный текст
Ответы Re: PQexecParams and types
Список pgsql-performance
Hello

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? i'm writing an interface for my php extension(i'm
not statisfied by the boundled), so i cannot figure out the type of the
fields in most cases. what should be done for the best performance in this
situation?


Bye,

Gergely Czuczy
mailto: phoemix@harmless.hu
PGP: http://phoemix.harmless.hu/phoemix.pgp

The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.


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

Предыдущее
От: Erki Kaldjärv
Дата:
Сообщение: Re: inserting large number of rows was: Re: Increasing
Следующее
От: David Teran
Дата:
Сообщение: cache whole data in RAM