| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | "Postgres General List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | PQexecParams question |
| Date: | 2008-10-11 17:40:02 |
| Message-ID: | 2f4958ff0810111040m4d88e4c8q5ffe0c83230a3021@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2008-10-11 17:41:59 | Re: Reg: Permission error in Windows psql while trying to read sql commands from file |
| Previous Message | Raj K | 2008-10-11 17:38:16 | Reg: Permission error in Windows psql while trying to read sql commands from file |