Re: help ! Is having likely function charindex of mssql in postgresql?

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: shiguoying <shiguoying(at)yeah(dot)net>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: help ! Is having likely function charindex of mssql in postgresql?
Date: 2008-04-08 05:52:33
Message-ID: 162867790804072252h7f1e0016t24a721f93e79aaf1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

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(at)yeah(dot)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
>

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Selena Deckelmann 2008-04-08 13:19:05 Re: help ! Is having likely function charindex of mssql in postgresql?
Previous Message Joshua D. Drake 2008-04-07 19:29:31 Re: pgus-general now up