TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN NEXT

From: "Maksim Likharev" <mlikharev(at)aurigin(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN NEXT
Date: 2003-06-11 23:37:16
Message-ID: 56510AAEF435D240958D1CE8C6B1770A016D2D39@mailc03.aurigin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I having some problem with table function that returns set of 'type',

Error says: Wrong record type supplied in return next, why it so?
Thanks.

type:
public.my_type ( name varchar(800), ncount int4, total int4 )

function:
CREATE FUNCTION public.doit() RETURNS SETOF public.my_type AS '
DECLARE
rec RECORD;
BEGIN
FOR rec IN
SELECT public.getname( fullname ) AS fullname,
COUNT( userid ) AS ncount,
ROUND(10000.0 * CAST( COUNT( userid ) AS bigint
) / 10000, 0) AS total
....
LOOP
RETURN NEXT rec;
END LOOP;
RETURN;
END;

Browse pgsql-general by date

  From Date Subject
Next Message Octavio Alvarez 2003-06-11 23:40:42 LC_COLLATE=es_MX in PgSQL 7.3.2
Previous Message Travis Hume 2003-06-11 23:35:58 need a method to ping a running database