Postgres Pro
Downloads
Home   >   mailing lists

select items based on 2 columns - Mailing list pgsql-sql

From Shaozhong SHI
Subject select items based on 2 columns
Date
Msg-id CA+i5JwYCPBDcenq_godJqtjApLyOeJHxo-Joova3wrAYtM6QOA@mail.gmail.com
Whole thread Raw
Responses Re: select items based on 2 columns  (Frank Streitzig <fstreitzig@gmx.net>)
Re: select items based on 2 columns  (Pierre Chevalier <pierre.chevalier1967@free.fr>)
List pgsql-sql
Tree view
The following is the type of data:

id  id_b   in    out
51 57     false false
51 42     true   false
51   32   false  false
51   76   false  true
51  49     true   false


How to do the following:

select id from tbl   if in is true and out is true are found?

Regards,

David

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible bug (or at least unexpected behavior)
Next
From: Frank Streitzig
Date:
Subject: Re: select items based on 2 columns