Re: position('' in '') returns 1 instead of 0 - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: position('' in '') returns 1 instead of 0
Date
Msg-id Pine.LNX.4.30.0104182352020.762-100000@peter.localdomain
Whole thread Raw
In response to position('' in '') returns 1 instead of 0  (pgsql-bugs@postgresql.org)
List pgsql-bugs
> Terry Carlin (terry@greatbridge.com) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> position('' in '') returns 1 instead of 0

This is in compliance with the SQL standard.  (SQL 1999, clause 6.17,
general rule 2 a), if you care.)

> While running an ODBC test suite against PostgreSQL 7.1, the test
> software reported that the ODBC command locate("", "") failed. It
> expected the result to be zero and it got a 1.

Maybe the locate() function should be implemented differently than
position().

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: position('' in '') returns 1 instead of 0
Next
From: Thomas Lockhart
Date:
Subject: Re: position('' in '') returns 1 instead of 0