Re: Query not producing expected result - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Query not producing expected result
Date
Msg-id CA+bJJbyUxwWux3NQKiebsdbzpb_52M16Ho1oxm5zM6cdUm-tSw@mail.gmail.com
Whole thread Raw
In response to Re: Query not producing expected result  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Query not producing expected result
List pgsql-general
Adrian..

On Wed, May 1, 2019 at 7:50 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> I should have made it clearer, my suggestion was mostly directed at
> Franciso's example.
...
> For this sort of thing, I have found range types to be a time and sanity
> saver. Just throwing it out there.

I've had problems with the functions, being used to the [start,end)
notation on paper. I'll look at them again.

But anyway, after so many years of not having intervals and operators,
I read "$start<= $val and $val < $end" as "$val in [$start,$end)", I
think it shares brain paths with "for(;;)" parsing to "forever /
loop". I would like to have the "$start <= $val < $end" which some
language whose name I do not remember has, for complex $vals.

Francisco Olarte.



pgsql-general by date:

Previous
From: Chuck Martin
Date:
Subject: Re: Query not producing expected result
Next
From: Adrian Klaver
Date:
Subject: Re: Query not producing expected result