WHERE col = ANY($1) extended to 2 or more columns?
От
Dominique Devienne
Тема
WHERE col = ANY($1) extended to 2 or more columns?
Дата
Msg-id
CAFCRh-_7VMpCBFk6iGMN12gJF2hfX-iWU1QReVrjsgyJt0wKiQ@mail.gmail.com
Список
Дерево обсуждения
WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne <ddevienne@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? Alban Hertroys <haramrae@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? "David G. Johnston" <david.g.johnston@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne <ddevienne@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: WHERE col = ANY($1) extended to 2 or more columns? "Peter J. Holzer" <hjp-pgsql@hjp.at>
Re: WHERE col = ANY($1) extended to 2 or more columns? Alban Hertroys <haramrae@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? "David G. Johnston" <david.g.johnston@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne <ddevienne@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne <ddevienne@gmail.com>
Re: WHERE col = ANY($1) extended to 2 or more columns? "David G. Johnston" <david.g.johnston@gmail.com>
Hi. We are implementing an API which takes a list of row keys, and must return info about those rows. To implement that efficiently, in as few round-trips as possible, we bind a (binary) array of keys (ints, uuids, or strings) and that works great, but only if the key is a scalar one.
Now we'd like to do the same for composite keys, and I don't know how to do that.
Is it possible? Could someone please help out or demo such a thing?
We are doing it in C++ using libpq, but a pure SQL or PL/pgSQL demo would still help (I think).
Thanks, --DD
В списке pgsql-general по дате отправления
От: Dominique Devienne
Дата:
