Re: [HACKERS] Oracle porting sample instr function

2012-07-06 Thread Roberto Mello
On Mon, Jul 2, 2012 at 8:51 PM, Greg Smith wrote: > > 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

Re: [HACKERS] Oracle porting sample instr function

2012-07-04 Thread Robert Haas
On Wed, Jul 4, 2012 at 3:50 AM, Albe Laurenz 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 Enterprise Pos

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) T

Re: [HACKERS] Oracle porting sample instr function

2012-07-03 Thread Robert Haas
On Tue, Jul 3, 2012 at 8:42 AM, Albe Laurenz 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 via pgsql-hackers maili

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 IN

[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 http://do