Re: [ask] Return Query

Поиск
Список
Период
Сортировка
От ataherster
Тема Re: [ask] Return Query
Дата
Msg-id 49BDABC1.4080809@yahoo.co.id
обсуждение исходный текст
Ответ на Re: [ask] Return Query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@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
>
>


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nagalingam, Karthikeyan"
Дата:
Сообщение: Re: deployment query
Следующее
От: Mike Charnoky
Дата:
Сообщение: Re: intermittant performance problem