Re: Refining query statement - Mailing list pgsql-general

From Rich Shepard
Subject Re: Refining query statement
Date
Msg-id alpine.LNX.2.20.1901171001300.18965@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Refining query statement  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Thu, 17 Jan 2019, David G. Johnston wrote:

> Off the top of my head (and this is a model I am quite familiar with
> even if I'm doing this email at speed):
>
> I'd suggest an actual activity table:

David,

   Adrian's suggestion of a Contacts table column called 'active' having a
boolean data type seems to me to be more compact. Testing active = true as a
condition in the WHERE clause will display only those People with active
contact needs.

Thanks very much,

Rich


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: Postgres Automated Failover
Next
From: Adrian Klaver
Date:
Subject: Re: Refining query statement