thanks Tom Lane, my problem resolved, I'm trying to re-create my table and function, and this working well
Tom Lane wrote:
> 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
>
>
