Hi all,
I believe this is a bug. The following function returns 'foo' instead
of null:
---
create or replace function test() returns varchar as '
declare
s varchar[] := ''{}'';
begin
s[1] := ''foo'';
s[1] := null;
return s[1];
end;
' l
r the first time, it should be fine.
This highlights another problem with our plpgsql function caching.
-------
Eugene Chow wrote:
My plpgsql function seems to be ignoring search_path when looking for
the right table to select fro
My plpgsql function seems to be ignoring search_path when looking for
the right table to select from. I'm running 7.3.4. Below is my test
code. Am I doing something wrong?
TIA, Gene Chow
test=> create or replace function getval() returns varchar as '
test'> declare val varchar;
test'> begin
tes
