Re: Assert single row returning SQL-standard functions

On Fri, Aug 29, 2025 at 10:34 AM Merlin Moncure <mmoncure@gmail.com> wrote:

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

This example seems unrelated to the point being made.

The query in the atomic sql function behaves no differently than an equivalent view.  OIDs don't care about search_path.