Re: position('' in '') returns 1 instead of 0

> 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