From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Cc: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Subject: | testing nested case-when scoping |
Date: | 2011-06-15 11:43:35 |
Message-ID: | BANLkTikJt3wab9XSisT-NUBh1jeC3q=yiQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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$_$;
CREATE FUNCTION fx2(text) RETURNS text
LANGUAGE sql
AS $_$ select case $1 when 'A' then 'a' else 'b' end$_$;
CREATE TABLE foo (
a integer
);
COPY foo (a) FROM stdin;
1
0
\.
postgres=# select fx2(fx1(fx(a))) from foo;
NOTICE: >>1<<
ERROR: invalid expression parameter reference (1 levels up, while
stack is only 1 elements deep)
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2011-06-15 12:02:59 | Re: pg_upgrade using appname to lock out other users |
Previous Message | Dave Page | 2011-06-15 11:16:01 | Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name |