From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
Cc: | "Postgres General List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PQexecParams question |
Date: | 2008-10-11 18:00:27 |
Message-ID: | 162867790810111100j5b7e84f2va98466fded860edf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2008/10/11 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:
> 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 ?
why you don't use array?
regards
Pavel Stehule
> ta
>
> --
> GJ
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kyle Cordes | 2008-10-11 18:03:41 | Need advice on PITR Slony(?) Backups etc. |
Previous 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 |