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

From Hiroshi Inoue
Subject Re: Re: position('' in '') returns 1 instead of 0
Date
Msg-id 3ADE6A14.4C72A32A@tpf.co.jp
Whole thread Raw
In response to position('' in '') returns 1 instead of 0  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tom Lane wrote:
>
> Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> > So now the question is what the ODBC standard says locate() should
> > return.
>
> Wups.  I neglected to notice the disconnect between the message subject
> and body... but you are right, "locate" might not be the same as
> "position" :-(
>

Hmm where is locate() changed to position() ?
ISTM neither psqlodbc driver nor pg backend changes the
function call locate() to position(.. in ..).

regards,
Hiroshi Inoue

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