Re: I remember why I suggested CREATE FUNCTION...AS NULL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: I remember why I suggested CREATE FUNCTION...AS NULL
Дата
Msg-id 27642.968464110@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: I remember why I suggested CREATE FUNCTION...AS NULL  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> ALTER FUNCTION numpeople() AS 
>> 'SELECT COUNT(*) FROM managers' LANGUAGE 'plpgsql';

> Actually, I think this would still work, because it
> doesn't check the table name existance until it's 
> used for the first time, not when it's created.

But SQL-language function bodies are checked at entry, not only
at first use.  (I consider it a deficiency of plpgsql that it
doesn't do likewise.)
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: I remember why I suggested CREATE FUNCTION...AS NULL
Следующее
От: "Stephan Szabo"
Дата:
Сообщение: Fw: I remember why I suggested CREATE FUNCTION...AS NULL