Re: Query not producing expected result

From: Francisco Olarte <folarte(at)peoplecall(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Chuck Martin <clmartin(at)theombudsman(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query not producing expected result
Date: 2019-05-01 18:09:52
Message-ID: CA+bJJbw_-52hQWPPoZ1q2mT_fcSRvtJ80Zp05hbbETnYgMBGFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 1, 2019 at 8:04 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> You don't have to use the functions:
> test_(postgres)# select dt_fld from dt_test where dt_fld <@
> '[2019-02-01, 2019-03-01)'::daterange ;

I knew there have to be a cast syntax ( I should have said I try to
avoid casts as well ). I will take your advice and learn more of
these, but all that operators and cast take quite a bit to learn (
specially as I do not do that much sql and I tend to forget operators
as I routinelly have to use about a dozen languages,that's why I try
to use the more common / old way ( and 30+ years of habit take a bit
to change ) ).

Thanks.
Francisco Olarte.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-05-01 18:13:57 Re: Query not producing expected result
Previous Message Francisco Olarte 2019-05-01 18:04:48 Re: Query not producing expected result