| From: | ataherster <ataherster(at)yahoo(dot)co(dot)id> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [ask] Return Query |
| Date: | 2009-03-16 01:30:41 |
| Message-ID: | 49BDABC1.4080809@yahoo.co.id |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)yahoo(dot)co(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | leopay | 2009-03-16 03:00:39 | is there any defect when use null column in postgresql? |
| Previous Message | ataherster | 2009-03-16 01:29:16 | [Fwd: Re: [ask] Return Query] |