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