Re: [ask] Return Query

ataherster <ataherster@yahoo.co.id> writes:
> ... but this function is not work with this error :
> ERROR:  structure of query does not match function result type
> CONTEXT:  PL/pgSQL function "penjualan" line 6 at RETURN QUERY

This looks like a known limitation in plpgsql: it's not very good with
rowtypes that contain dropped columns.  Have you dropped some columns
in table PENJUALAN?  If so, try remaking the table from scratch.

            regards, tom lane