Re: Assert single row returning SQL-standard functions

Поиск

Список

Период

Сортировка

От	Merlin Moncure
Тема	Re: Assert single row returning SQL-standard functions
Дата	29 августа 20:34:27
Msg-id	CAHyXU0z-aSgsSZu9gKofnUiB2+_XdGvxwj-Lco0pk3bA9kiVNg@mail.gmail.com обсуждение исходный текст
Ответ на	Assert single row returning SQL-standard functions ("Joel Jacobson" <joel@compiler.org>)
Ответы	Re: Assert single row returning SQL-standard functions Re: Assert single row returning SQL-standard functions
Список	pgsql-hackers

On Fri, Aug 29, 2025 at 1:03 AM Joel Jacobson <joel@compiler.org> wrote:

*) Renaming of database objects seamless, thanks to function body being
parsed at function definition time and stored as expression nodes.

How does that work in practice? for current SQL (not pl/pgsql) functions, this will fail:

create function f() returns int as $$ create temp table i(i int); select * from i; $$ language sql;

ERROR: relation "i" does not exist

Also, how do search_path interactions work in your understanding?

merlin

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