Re: Refining query statement

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Refining query statement
Дата
Msg-id alpine.LNX.2.20.1901171001300.18965@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Refining query statement  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: AI Rumman
Дата:
Сообщение: Re: Postgres Automated Failover
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Refining query statement