Re: Using a boolean column with IF / THEN

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using a boolean column with IF / THEN
Date: 2020-12-06 16:28:37
Message-ID: CAADeyWhHDq=uzJv4tbfefMO_QthFdMLtFi=f-BEZVYfMF-Mnyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Dec 5, 2020 at 9:00 PM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2020-12-06 17:08:36 SELECT but only if not present in another table
Previous Message David G. Johnston 2020-12-06 16:05:41 Re: The hidden cost of limit-offset