From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
---|---|
To: | <depesz(at)depesz(dot)com> |
Cc: | "Merlin Moncure" <mmoncure(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to fix set-valued function called in contextthat cannot accept a set in earlier versions |
Date: | 2010-04-05 14:33:59 |
Message-ID: | E9166C136EEA496085389F56CE846800@andrusnotebook |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Than you.
> remove begin and end from above function.
I tried code belwo in 8.3 but got error
ERROR: column "line" does not exist
LINE 29: select * from wordwrap(line,linelen);
Andrus.
CREATE OR REPLACE FUNCTION wordwrap(line text, linelen integer)
RETURNS SETOF text as $$
DECLARE
words text[] := string_to_array(line,' ');
i integer;
res text:='';
BEGIN
if trim(line)='' then
return next '';
return;
end if;
for i IN 1 .. array_upper(words,1) LOOP
if length(res)+length(words[i]) > linelen THEN
return next res;
res := '';
END IF ;
if res<>'' then
res := res || ' ';
end if;
res := res || words[i];
end loop;
return next res;
END
$$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION wordwrap83(line text, linelen integer)
RETURNS SETOF text as $$
select * from wordwrap(line,linelen);
$$ LANGUAGE sql;
select wordwrap83('fdgdf',10)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2010-04-05 15:19:20 | Re: How to fix set-valued function called in context that cannot accept a set in earlier versions |
Previous Message | hubert depesz lubaczewski | 2010-04-05 14:30:21 | Re: How to fix set-valued function called in context that cannot accept a set in earlier versions |