On Mon, Jul 2, 2012 at 8:51 PM, Greg Smith <g...@2ndquadrant.com> wrote: >
<snip> > The INSTR implementation in the docs will instead search backwards from the > end of the string if you tell it to start at 0, same as if you gave it a > negative input. I think it's therefore possible to get the plpgsql version > to return a value in cases Oracle would instead return 0. Seems like a > straightforward thing to confirm and change the sample to do differently; > just have to add an explicit test for a 0 value of beg_index. I wrote that sample eons ago with the plpgsql-porting doc. I probably overlooked the 0 behavior. Thanks for reporting Greg, and thanks Albe for providing a patch. Roberto -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
