Re: TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN NEXT - Mailing list pgsql-general

From Maksim Likharev
Subject Re: TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN NEXT
Date
Msg-id 56510AAEF435D240958D1CE8C6B1770A014A0C4F@mailc03.aurigin.com
Whole thread Raw
In response to TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN NEXT  ("Maksim Likharev" <mlikharev@aurigin.com>)
List pgsql-general
Ok, found what the problem is, count() aggregate returns bigint.

-----Original Message-----
From: Maksim Likharev
Sent: Wednesday, June 11, 2003 4:37 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN
NEXT


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;



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-general by date:

Previous
From: "Octavio Alvarez"
Date:
Subject: LC_COLLATE=es_MX in PgSQL 7.3.2
Next
From: Edmund Dengler
Date:
Subject: Performance of a query