Re: create policy statement USING clause

2024-11-13 Thread Mark Phillips
Thank you for the reply. I appreciate it very much. I checked the data for null in the column values, but I didn't any. I started over from the beginning with a fresh clone of the database, and followed the set up in ordered fashion, including a little routine to assure valid data in the column

Re: create policy statement USING clause

2024-11-12 Thread Laurenz Albe
On Mon, 2024-11-11 at 15:10 -0800, Mark Phillips wrote: > PostgreSQL 12 Upgrade now! > Given a table “customer” with a column “deadfiled” of the type boolean. The > column > deadfiled is used to indicate that a row is “in the trash bin”. The app has a > window > that lists the contents of the “

create policy statement USING clause

2024-11-12 Thread Mark Phillips
PostgreSQL 12 Given a table “customer” with a column “deadfiled” of the type boolean. The column deadfiled is used to indicate that a row is “in the trash bin”. The app has a window that lists the contents of the “trash bin”, which any rows with deadfiled = true. Row so marked should be excluded