Re: OVERLAPS - Mailing list pgsql-general

From Mike Castle
Subject Re: OVERLAPS
Date
Msg-id 20001201190558.B12425@thune.mrc-home.org
Whole thread Raw
In response to OVERLAPS  ("Alex Bolenok" <abolen@chat.ru>)
List pgsql-general
On Thu, Nov 30, 2000 at 04:22:20PM +0300, Alex Bolenok wrote:
> peroon=# SELECT OVERLAPS('yesterday', 'today', 'today', 'tomorrow');
> ERROR:  parser: parse error at or near "overlaps"

Try using it as an operator instead of a function:

test=# select ('yesterday'::timestamp, 'today'::timestamp) overlaps
('today'::timestamp, 'tomorrow'::timestamp);
 overlaps
----------
 f
(1 row)

> What am I doing wrong? Is there any way to make this function work?

Is the parser getting confused when it shouldn't (ie, if the functions were
called something beside "OVERLAPS" would it then work)?

mrc
--
       Mike Castle       Life is like a clock:  You can work constantly
  dalgoda@ix.netcom.com  and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day.  -- mrc
    We are all of us living in the shadow of Manhattan.  -- Watchmen

pgsql-general by date:

Previous
From: 100.179370@germanynet.de (Martin Jacobs)
Date:
Subject: Re: strange error (32 512)
Next
From: Adam Haberlach
Date:
Subject: Re: postgres blobs and PHP