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

From Thomas Lockhart
Subject Re: position('' in '') returns 1 instead of 0
Date
Msg-id 3ADEE62B.3D5BED97@alumni.caltech.edu
Whole thread Raw
In response to position('' in '') returns 1 instead of 0  (pgsql-bugs@postgresql.org)
List pgsql-bugs
> Hmm where is locate() changed to position() ?
> ISTM neither psqlodbc driver nor pg backend changes the
> function call locate() to position(.. in ..).

There is a mapping table in the driver of ODBC function calls to
PostgreSQL function calls. In this case, locate() is transformed into
strpos(), which is probably the underlying function implementing
position() also.

Terry, any word on locate() vs position() specs?

                         - Thomas

pgsql-bugs by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Re: position('' in '') returns 1 instead of 0
Next
From: VASQUEZ_JASON@LILLY.COM
Date:
Subject: startup scripts don't function properly