Postgres Pro
Downloads
Home   >   mailing lists

Re: Select rows when all all ids of its children records matches - Mailing list pgsql-general

From David G. Johnston
Subject Re: Select rows when all all ids of its children records matches
Date
Msg-id CAKFQuwZN-Lk3ErCACMdQZYDiiCto0NkrgTKZNKshkgxN-iSd=A@mail.gmail.com
Whole thread Raw
In response to Re: Select rows when all all ids of its children records matches  (Arup Rakshit <ar@zeit.io>)
Responses Re: Select rows when all all ids of its children records matches  (Arup Rakshit <ar@zeit.io>)
List pgsql-general
Tree view
On Wednesday, September 12, 2018, Arup Rakshit <ar@zeit.io> wrote:
IN is OR, I want the AND logic. Select posts which has tag 1, 2 and 3 ( tag ids )

Build arrays and then use the “contains” operator.

David J. 

pgsql-general by date:

Previous
From: Arup Rakshit
Date:
Subject: Re: Select rows when all all ids of its children records matches
Next
From: Arup Rakshit
Date:
Subject: Re: Select rows when all all ids of its children records matches