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

> Terry Carlin (terry(at)greatbridge(dot)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(at)gmx(dot)net http://funkturm.homeip.net/~peter