Re: Using a boolean column with IF / THEN

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Saturday, December 5, 2020, Alexander Farber <alexander.farber@xxxxxxxxx> wrote:

Good evening,

hopefully my question is not too stupid, but -

in a 13.1 database I have a words_users table with a boolean column:

        -- the user is not allowed to chat or change the motto

        muted         boolean NOT NULL DEFAULT false,

Currently I check the value as follows, but I wonder if this is the best way with PL/pgSQL -

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.

David J.