Re: [SQL] Using a RETURN NEXT

[Joe Conway]

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 the error you are 
getting usually indicates you did something like:

  SELECT word_case();

but you should have done:

  (define the function to return setof record)
  SELECT * FROM word_case() AS (message text);
or

  CREATE TYPE word_case_type AS (message text);
  (define the function to return setof word_case_type)
  SELECT * FROM word_case();
HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]