Re: [HACKERS] testing nested case-when scoping

2011-07-05 Thread Pavel Stehule
2011/7/5 Robert Haas : > On Wed, Jun 15, 2011 at 7:43 AM, Pavel Stehule > wrote: >> Hello Heikki, >> >> probably I found a bug in patch: >> >> CREATE FUNCTION fx(i integer) RETURNS integer >>    LANGUAGE plpgsql >>    AS $$begin raise notice '>>%<<', i; return i; end;$$; >> >> CREATE FUNCTION fx1

Re: [HACKERS] testing nested case-when scoping

2011-07-05 Thread Robert Haas
On Wed, Jun 15, 2011 at 7:43 AM, Pavel Stehule wrote: > Hello Heikki, > > probably I found a bug in patch: > > CREATE FUNCTION fx(i integer) RETURNS integer >    LANGUAGE plpgsql >    AS $$begin raise notice '>>%<<', i; return i; end;$$; > > CREATE FUNCTION fx1(integer) RETURNS text >    LANGUAGE

[HACKERS] testing nested case-when scoping

2011-06-15 Thread Pavel Stehule
Hello Heikki, probably I found a bug in patch: CREATE FUNCTION fx(i integer) RETURNS integer LANGUAGE plpgsql AS $$begin raise notice '>>%<<', i; return i; end;$$; CREATE FUNCTION fx1(integer) RETURNS text LANGUAGE sql AS $_$ select case $1 when 1 then 'A' else 'B' end$_$; CREAT