Re: Problem with return type of function ??? (corrected)

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Problem with return type of function ??? (corrected)
Дата
Msg-id 4AE07507.5050900@archonet.com
обсуждение исходный текст
Ответ на Re: Problem with return type of function ??? (corrected)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Problem with return type of function ??? (corrected)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Tom Lane wrote:
> Denis BUCHER <dbucherml@hsolutions.ch> writes:
> 
> Does that table have any dropped columns?  If you don't remember
> whether you ever dropped any columns, a quick look into pg_attribute
> will tell you:
> select attname from pg_attribute where attrelid = 'rma.serial_number'::regclass;
> 
> plpgsql isn't tremendously good with rowtypes that contain dropped
> columns.  

I thought that only applied to columns dropped after the function was
defined. Live and learn.

--  Richard Huxton Archonet Ltd


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Problem with return type of function ???
Следующее
От: Denis BUCHER
Дата:
Сообщение: Re: Problem with return type of function ??? (corrected)