Re: help ! Is having likely function charindex of mssql in postgresql? - Mailing list pgsql-advocacy

From Selena Deckelmann
Subject Re: help ! Is having likely function charindex of mssql in postgresql?
Date
Msg-id 2b5e566d0804080619v2ec8696es6887c53836f7c46b@mail.gmail.com
Whole thread Raw
In response to Re: help ! Is having likely function charindex of mssql in postgresql?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-advocacy
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

pgsql-advocacy by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: help ! Is having likely function charindex of mssql in postgresql?
Next
From: Dan Langille
Date:
Subject: PGCon - only a few weeks to go