Thanks a lot Gaetano, Joe
Now, it is working.
--- Mendola Gaetano <[EMAIL PROTECTED]> escribió: >
From: "Mr Weinbach, Larry" <[EMAIL PROTECTED]>
>
> > But at execution time I am getting thi error :
> >
> > WARNING: Error occurred while executing PL/pgSQL
> > function word_case
> > WARNING: l
From: "Mr Weinbach, Larry" <[EMAIL PROTECTED]>
> But at execution time I am getting thi error :
>
> WARNING: Error occurred while executing PL/pgSQL
> function word_case
> WARNING: line 5 at return next
> ERROR: Set-valued function called in context that
> cannot accept a set
>
> I also tried
Mr Weinbach, Larry wrote:
But at execution time I am getting thi error :
WARNING: Error occurred while executing PL/pgSQL
function word_case
WARNING: line 5 at return next
ERROR: Set-valued function called in context that
cannot accept a set
You didn't show the execution time SQL statement, but
Hi all,
I found this example from Postgres site
create or replace function GetRows(text) returns setof
record as
'
declare
r record;
begin
for r in EXECUTE ''select * from '' || $1 loop
return next r;
end loop;
return;
end
'
language 'plpgsql';
I am trying to use the sam
