Hi Tom, Thank you very much for the clarification.
Let me set an empty string validation, before passing it to position() from API. Thank you once again. Regards, Dinesh manojadinesh.blogspot.com On 2 May 2013 19:19, "Tom Lane" <t...@sss.pgh.pa.us> wrote: > dinesh kumar <dineshkuma...@gmail.com> writes: > > postgres=# select position('' in 'PostgreSQL'); *// position(Substring as > > an empty string) is returning 1.* > > position > > ---------- > > 1 > > (1 row) > > This is correct according to the SQL standard: > > <position expression> determines the first position, if any, at > which one string, S1, occurs within another, S2. If S1 is of > length > zero, then it occurs at position 1 (one) for any value of S2. If > S1 > does not occur in S2, then zero is returned. > > regards, tom lane >