Re: Group by clause creating "ERROR: wrong record type supplied in RETURN NEXT" (version 8.1.11 -- grr...) - Mailing list pgsql-general

Webb Sprague wrote:
> select * from mkn.query_table_data ('select sum(p087001) as pop
>         from datatable_00040 group by substr(geo_id, 13, 6) order by
> pop desc limit 10')
>     as FOO (pop integer);
>
> ERROR:  wrong record type supplied in RETURN NEXT
> CONTEXT:  PL/pgSQL function "query_table_data" line 15 at return next
>

sum(int) returns bigint

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au