Re: SQL-standard function body

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SQL-standard function body
Дата
Msg-id 496794.1593546216@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: SQL-standard function body  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2020-06-30 19:49:04 +0200, Peter Eisentraut wrote:
>> The function body is parsed at function definition time and stored as
>> expression nodes in probin.  So at run time, no further parsing is
>> required.

> Isn't a consequence of that that we'd get a lot more errors if any DDL
> is done to tables involved in the query? In contrast to other languages
> we'd not be able to handle column type changes etc, right?

I suppose it'd act like column references in a view, ie the dependency
mechanisms would forbid you from changing/dropping any column mentioned
in one of these functions.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: warnings for invalid function casts
Следующее
От: Mark Dilger
Дата:
Сообщение: Re: new heapcheck contrib module