PQexecParams question

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема PQexecParams question
Дата
Msg-id 2f4958ff0810111040m4d88e4c8q5ffe0c83230a3021@mail.gmail.com
обсуждение исходный текст
Ответы Re: PQexecParams question  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general
Hey folks,

I have here piece of code, that I wrote some time ago - works fine, but I was wondering - if it can be improved. 
This is used to grab id list, not present on submited list. Query usually looks like that;
select id from foo where id not in ($1, $2, $3...);

and I was wondering, is it possible to call PQexecParams with query, that doesn't have a longish list of dollar params (in my case up to 200), but instead uses some other syntax, such as:
select id from foo where id not in ($1...$200);

If not, to guys hacking libpq and area, would it be possible to request such a nice and neat feature ?

ta

--
GJ

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

Предыдущее
От: "Raj K"
Дата:
Сообщение: Reg: Permission error in Windows psql while trying to read sql commands from file
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Reg: Permission error in Windows psql while trying to read sql commands from file