Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)
Date: 2012-07-24 08:39:12
Message-ID: julmvg$fpc$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-07-17, David Johnston <polobo(at)yahoo(dot)com> wrote:
> On Jul 17, 2012, at 2:32, Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> wrote:
>>
>> Is that even possible to implement? (e.g.: "SELECT * FROM log WHERE
>> start_date <> 'XXXX-YY-ZZ' and end_date = 'ZZZZ-AA-BB'" - when both
>> start_date and end_date possibly have 'infinity')
>
> I was unclear. I intended "<>" to mean "greater than and less than comparisons" as opposed to not equals comparisons. Equality and inequality are two sides to the same coin.

confusingly in mathematics greater-than and less-than are classed as inequalities

--
⚂⚃ 100% natural

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Mańk 2012-07-24 09:31:07 Re: Odd corruption issue reported on dba.stackexchange.com, need advice
Previous Message Adam Crews 2012-07-24 02:02:45 Re: postgres 9 bind address for replication