Postgres Pro
Downloads
Home   >   mailing lists

Re: Using a boolean column with IF / THEN - Mailing list pgsql-general

From Alexander Farber
Subject Re: Using a boolean column with IF / THEN
Date
Msg-id CAADeyWhHDq=uzJv4tbfefMO_QthFdMLtFi=f-BEZVYfMF-Mnyw@mail.gmail.com
Whole thread Raw
In response to Re: Using a boolean column with IF / THEN  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Sat, Dec 5, 2020 at 9:00 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
Maybe not “simpler” but for all those checks you could write a single query that pulls out all the data at once into a record variable and test against the columns pf that instead of executing multiple queries.

Thank you! 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: The hidden cost of limit-offset
Next
From: Alexander Farber
Date:
Subject: SELECT but only if not present in another table