Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oKy3r-00072u-UX for pgsql-sql@arkaria.postgresql.org; Mon, 08 Aug 2022 08:24:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oKy3q-0000Qi-ID for pgsql-sql@arkaria.postgresql.org; Mon, 08 Aug 2022 08:24:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oKy3q-0000QZ-7t for pgsql-sql@lists.postgresql.org; Mon, 08 Aug 2022 08:24:30 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oKy3o-0006nd-4L for pgsql-sql@lists.postgresql.org; Mon, 08 Aug 2022 08:24:29 +0000 Received: by mail-ej1-x632.google.com with SMTP id gk3so15180732ejb.8 for ; Mon, 08 Aug 2022 01:24:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:subject:message-id:date:from:mime-version:from:to:cc; bh=mwMD+7de7T4w2ZsrnzPYr9ui8LNMLAyI7tpiAkmw0sM=; b=GbFXYRz1BxdKqzLfYev1f3f/q0t7DH9MorjRdBT9EaSQiwmwQYmlCEuSRieNV4aoGT sc/WTxCZLx1l7W/P23jiu2Uc0BXQVWhzjD6lhNQ2D36i5tUTMZMEW7uGGrAZEwAu6BPF B992eAtvBz8te1PaWUYmumrS8uwhJLOLxsqpd2C2rP0UG8zYCiHt252wUHIWR2/07EG8 Ce+xqdtoSZ5pQRZjVsw2nN7SKTUU96QqU7/sYjS8QNBCCl+Q5bhggRFO5uOKYEDCGwIp 58saP60Wxr0FoQuC3zR5+OycBF/vJtxiDCatFXXImMTDzEU5wCtdpAjs8B5qU61F2oUK 5cCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc; bh=mwMD+7de7T4w2ZsrnzPYr9ui8LNMLAyI7tpiAkmw0sM=; b=GnQYl/sexd/YWe8xf5j8V/1lQDVzPXm7Yw5lOjnXj7dFHJUfSm4aOt7rLeZJY7TerS FivIHv8vOYRMYO/oTdRgeaPMuF4BMrAPLZkPqRtW4rPzXLX51qN/A40W5p33AEXeDTyz FTB/9RECmAC2rPMIx0XSTUj+98C3mdQy6HkFDc4RyPLXFmzRH8oHFXY0j/P7Zjuq3Jg8 dIMYu9eNcrFBxRHmFweBqKwm0UDPvhg3ZXdme08KGPmmvyUfJb+dg8kl15g8cLfHdgdt /IfXBZljkLREvVQftV0qJgnFaGIoUwFFtawYLsNItB0RmA5D/gHQWpSNmFiGy01blGyb fvKw== X-Gm-Message-State: ACgBeo3ufx7aDQjKsAx+CJkaX0wsWOsi9M+n0MzBElDWS2Hj+XUbSoYm 0vJjd7pjOd4eSDfgDXm383fpAQ7FdkkMgiRQ+JSvfqD+ X-Google-Smtp-Source: AA6agR6YtmJFjpbOJ707F6wsBT+YoMUTLOqyHlaPR57fEyXmpE+Ud/kgimz0YxsvS3LmjQarG05dlAH2z5B+7NgNIZ8= X-Received: by 2002:a17:906:cc0c:b0:730:8bbb:69ac with SMTP id ml12-20020a170906cc0c00b007308bbb69acmr13059068ejb.392.1659947065997; Mon, 08 Aug 2022 01:24:25 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Mon, 8 Aug 2022 09:24:14 +0100 Message-ID: Subject: select items based on 2 columns To: pgsql-sql Content-Type: multipart/alternative; boundary="00000000000036fef805e5b68b62" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000036fef805e5b68b62 Content-Type: text/plain; charset="UTF-8" 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 --00000000000036fef805e5b68b62 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
The following is the type of data:

id= =C2=A0 id_b=C2=A0 =C2=A0in=C2=A0 =C2=A0 out
51 57=C2=A0 =C2=A0 = =C2=A0false false
51 42=C2=A0 =C2=A0 =C2=A0true=C2=A0 =C2=A0false=
51=C2=A0 =C2=A032=C2=A0 =C2=A0false=C2=A0 false
51=C2= =A0 =C2=A076=C2=A0 =C2=A0false=C2=A0 true
51=C2=A0 49=C2=A0 =C2= =A0 =C2=A0true=C2=A0 =C2=A0false


Ho= w to do the following:

select id from tbl=C2=A0 = =C2=A0if in is true and out is true are found?

Reg= ards,

David
--00000000000036fef805e5b68b62--