Re: using possibly null timestamptz columns

From: James Cloos <cloos(at)jhcloos(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: using possibly null timestamptz columns
Date: 2016-09-29 15:48:02
Message-ID: m34m4ywvv1.fsf@carbon.jhcloos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

TL> So this just reduces to WHERE tstzrange(s, e) @> now().

Thank you! I forgot about the range types.

I may even switch to a single range column instead of the separate start
and end columns.

-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 0x997A9F17ED7DAEA6

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrey Avakimov 2016-10-04 12:20:02 PLPython and named arguments
Previous Message Tom Lane 2016-09-29 13:15:22 Re: using possibly null timestamptz columns