Postgres Pro
Downloads
Home   >   mailing lists

Re: using possibly null timestamptz columns - Mailing list pgsql-sql

From James Cloos
Subject Re: using possibly null timestamptz columns
Date
Msg-id m34m4ywvv1.fsf@carbon.jhcloos.org
Whole thread Raw
In response to Re: using possibly null timestamptz columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.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@jhcloos.com>         OpenPGP: 0x997A9F17ED7DAEA6

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: using possibly null timestamptz columns
Next
From: "Andrey Avakimov"
Date:
Subject: PLPython and named arguments