Re: [HACKERS] Oracle porting sample instr function

2012-07-06 Thread Roberto Mello
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

Re: [HACKERS] Oracle porting sample instr function

2012-07-04 Thread Robert Haas
On Wed, Jul 4, 2012 at 3:50 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote: Robert Haas wrote: I can confirm that Oracle returns 0 if the third argument to INSTR is 0. Can someone provide a suitable doc patch? Thanks, committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The

Re: [HACKERS] Oracle porting sample instr function

2012-07-04 Thread Albe Laurenz
Robert Haas wrote: I can confirm that Oracle returns 0 if the third argument to INSTR is 0. Can someone provide a suitable doc patch? Here you are. Yours, Laurenz Albe instr-doc.patch Description: instr-doc.patch -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To

Re: [HACKERS] Oracle porting sample instr function

2012-07-03 Thread Albe Laurenz
Greg Smith wrote: A web site doc comment from user skong today points out a small issue around the sample INSTR function given in plpgsql-porting.html that I can't confirm (none of those dirty Oracle instances here today), but it sounds legit. A look at Oracle's documentation on the INSTR

Re: [HACKERS] Oracle porting sample instr function

2012-07-03 Thread Robert Haas
On Tue, Jul 3, 2012 at 8:42 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote: I can confirm that Oracle returns 0 if the third argument to INSTR is 0. Can someone provide a suitable doc patch? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent

[HACKERS] Oracle porting sample instr function

2012-07-02 Thread Greg Smith
A web site doc comment from user skong today points out a small issue around the sample INSTR function given in plpgsql-porting.html that I can't confirm (none of those dirty Oracle instances here today), but it sounds legit. A look at Oracle's documentation on the INSTR function at