Re: Select rows when all all ids of its children records matches

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: Select rows when all all ids of its children records matches
Дата
Msg-id EDC3D41A-E121-4245-BE30-AA017DDACA49@zeit.io
обсуждение исходный текст
Ответ на Re: Select rows when all all ids of its children records matches  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Select rows when all all ids of its children records matches
Re: Select rows when all all ids of its children records matches
Список pgsql-general
Дерево обсуждения
Can you show me the SQL construction? Do I need to use `WITH`?


Thanks,

Arup Rakshit



On 12-Sep-2018, at 9:13 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

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 по дате отправления: