Re: WHERE col = ANY($1) extended to 2 or more columns?

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: WHERE col = ANY($1) extended to 2 or more columns?
Дата
Msg-id CAFCRh-_yM=03ts=Es73ejoEARJKfymc7RAk8DzKpF2TXsEy++w@mail.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?
Список pgsql-general
Дерево обсуждения
On Thu, Feb 9, 2023 at 4:51 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Feb 9, 2023 at 8:41 AM Dominique Devienne <ddevienne@gmail.com> wrote:
Now we'd like to do the same for composite keys, and I don't know how to do that.

An array-of-composites is simply:
SELECT ARRAY[ ROW(1, 'one'), ROW(2, 'two') ]::composite_type[];

Thanks. I don't consider that "simple" myself :). But I'm definitely not an advanced PostgreSQL user!
Would still appreciate a more fleshed out demo, if anyone is kind enough to provide it. Thanks, --DD 

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