Postgres Pro
Downloads
Home   >   mailing lists

Position() Bug ? In PostgreSQL 9.2 - Mailing list pgsql-general

From dinesh kumar
Subject Position() Bug ? In PostgreSQL 9.2
Date
Msg-id CALnrH7rO0WYKK2aHTWLKwKjOy08Tqf8PSiz_07LHp05OKmVZmw@mail.gmail.com
Whole thread Raw
Responses Re: Position() Bug ? In PostgreSQL 9.2
Re: Position() Bug ? In PostgreSQL 9.2
List pgsql-general
Tree view
Hello Team,

I would like to know whether the following behavior is a BUG or an expected behavior. If this is a duplicated case, then kindly ignore.

postgres=# SELECT version();
                           version
-------------------------------------------------------------
 PostgreSQL 9.2.3, compiled by Visual C++ build 1600, 32-bit
(1 row)


postgres=# select position('P' in 'PostgreSQL');
 position
----------
        1
(1 row)


postgres=# select position('' in 'PostgreSQL'); // position(Substring as an empty string) is returning 1.
 position
----------
        1
(1 row)

Kindly let me know, if anything i miss here.

Regards,
Dinesh

pgsql-general by date:

Previous
From: dinesh kumar
Date:
Subject: Re: PostgreSQL registry entries for apt-get/yum/rpm install
Next
From: Amit Langote
Date:
Subject: Re: Position() Bug ? In PostgreSQL 9.2