Re: function with a composite type calling another function - Mission Impossible?

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: function with a composite type calling another function - Mission Impossible?
Дата
Msg-id
24964.1086191039@sss.pgh.pa.us
Ответ на
function with a composite type calling another function - Mission Impossible? (Riccardo G. Facchini)
Список
Дерево обсуждения
function with a composite type calling another function - Mission Impossible? "Riccardo G. Facchini" <abief_ag_-postgresql@yahoo.com>
Re: function with a composite type calling another function - Mission Impossible? Tom Lane <tgl@sss.pgh.pa.us>
Re: function with a composite type calling another function - Mission Impossible? "Riccardo G. Facchini" <abief_ag_-postgresql@yahoo.com> 
"Riccardo G. Facchini"  writes:
> declare my_new_complex complex_number;

> select * from complex_to_complex(my_new_complex) into my_result;

> ERROR:  column "my_new_complex" does not exist

plpgsql doesn't presently cope with passing whole-row variables into SQL
expressions, which is essentially what you've got here.  There's some
chance it will work in time for 7.5.
		regards, tom lane
В списке pgsql-sql по дате отправления
Предыдущее
От: Riccardo G. Facchini
Дата:
Следующее
От: Riccardo G. Facchini
Дата:
FAQ