Re: [BUGS] BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

2012-08-16 Thread Bruce Momjian
On Wed, Nov 30, 2011 at 03:36:11PM -0500, Robert Haas wrote: > On Tue, Nov 29, 2011 at 9:32 PM, Bruce Momjian wrote: > > Tom Lane wrote: > >> "David Fetter" writes: > >> >     IF EXISTS (SELECT 1 INTO STRICT i) THEN > >> >         RAISE NOTICE '%', a; > >> >     END IF; > >> > >> Umm ... are you

Re: [BUGS] BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

2011-11-30 Thread Robert Haas
On Tue, Nov 29, 2011 at 9:32 PM, Bruce Momjian wrote: > Tom Lane wrote: >> "David Fetter" writes: >> >     IF EXISTS (SELECT 1 INTO STRICT i) THEN >> >         RAISE NOTICE '%', a; >> >     END IF; >> >> Umm ... are you just complaining that the error message isn't very >> helpful, or are you act

Re: [BUGS] BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

2011-11-29 Thread Bruce Momjian
Tom Lane wrote: > "David Fetter" writes: > > IF EXISTS (SELECT 1 INTO STRICT i) THEN > > RAISE NOTICE '%', a; > > END IF; > > Umm ... are you just complaining that the error message isn't very > helpful, or are you actually expecting that to do something useful? > If the latter, w

Re: [BUGS] BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

2011-06-18 Thread Tom Lane
"David Fetter" writes: > IF EXISTS (SELECT 1 INTO STRICT i) THEN > RAISE NOTICE '%', a; > END IF; Umm ... are you just complaining that the error message isn't very helpful, or are you actually expecting that to do something useful? If the latter, what exactly? I'm particularly c

Re: [BUGS] BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

2011-06-18 Thread Pavel Stehule
Hello 2011/6/18 David Fetter : > > The following bug has been logged online: > > Bug reference:      6067 > Logged by:          David Fetter > Email address:      dfet...@vmware.com > PostgreSQL version: 9.0.4 > Operating system:   Linux > Description:        In PL/pgsql, EXISTS(SELECT ... INTO...