Re: [ask] Return Query

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
>
>