Thread: help ! Is having likely function charindex of mssql in postgresql?
hello:
In my project ,i want to test which is more effective between 'like' and charindex .but i can't find it in postgresql.Could you help find it like this.
thanx
eagle from china
Hello PostgreSQL doesn't support charindex function, but it has similar functions position(substring in string) or strpos(string, substring) file:///home/pavel/src/pgsql/doc/src/sgml/functions-string.html Regards Pavel Stehule On 07/04/2008, shiguoying <shiguoying@yeah.net> wrote: > > > > hello: > In my project ,i want to test which is more effective between 'like' > and charindex .but i can't find it in postgresql.Could you help find it like > this. > thanx > > eagle from china >
Re: help ! Is having likely function charindex of mssql in postgresql?
From
"Selena Deckelmann"
Date:
Hello! On Mon, Apr 7, 2008 at 10:52 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote: > Hello > > PostgreSQL doesn't support charindex function, but it has similar > functions position(substring in string) or strpos(string, substring) This is the correct URL: http://www.postgresql.org/docs/8.3/static/functions-string.html > On 07/04/2008, shiguoying <shiguoying@yeah.net> wrote: > > > > > > > > hello: > > In my project ,i want to test which is more effective between 'like' > > and charindex .but i can't find it in postgresql.Could you help find it like > > this. > > thanx > > > > eagle from china > > > > -- > Sent via pgsql-advocacy mailing list (pgsql-advocacy@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-advocacy > -- Selena Deckelmann United States PostgreSQL Association - http://www.postgresql.us PDXPUG - http://pugs.postgresql.org/pdx Me - http://www.chesnok.com/daily