Position() Bug ? In PostgreSQL 9.2

From: dinesh kumar <dineshkumar02(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Position() Bug ? In PostgreSQL 9.2
Date: 2013-05-02 12:09:23
Message-ID: CALnrH7rO0WYKK2aHTWLKwKjOy08Tqf8PSiz_07LHp05OKmVZmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
manojadinesh.blogspot.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amit Langote 2013-05-02 13:25:28 Position() Bug ? In PostgreSQL 9.2
Previous Message dinesh kumar 2013-05-02 12:03:14 Re: PostgreSQL registry entries for apt-get/yum/rpm install