Postgres Pro
Downloads
Home   >   mailing lists

Thread: tuplets in

tuplets in

From
Hans Ginzel
Date:
Hello!

How to say
... WHERE (group_id, id) NOT IN (SELECT a, b FROM...)
please?

Analogous to
... WHERE id NOT IN (SELECT a FROM...)
but in vector form.

Regards
Hans Ginzel

Re: tuplets in

From
Thomas Kellerer
Date:
Hans Ginzel wrote on 09.07.2015 22:44:
> How to say
> ... WHERE (group_id, id) NOT IN (SELECT a, b FROM...)
> please?

That syntax works. What exactly is your problem?