Re: BETWEEN bug?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: BETWEEN bug?
Date: 2002-07-10 21:57:35
Message-ID: 200207101457.35614.josh@agliodbs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Stephan,

> Spec thing.
>
> In SQL92,
> "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".
>
> In SQL99, there's BETWEEN SYMMETRIC and ASYMMETRIC, but ASYMMETRIC is the
> default which is the same as the SQL92 version afaics. Symmetric is an
> optional feature that I think Christopher's been working on.

Thanks. Thought it was something like that.

Thank you guys, though, OVERLAPS is asymmetric.

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Durst 2002-07-11 00:37:41 Returning rows from functions
Previous Message Ian Barwick 2002-07-10 20:45:44 Re: Insert Function