Home > mailing lists

Re: Assert single row returning SQL-standard functions - Mailing list pgsql-hackers

From	Merlin Moncure
Subject	Re: Assert single row returning SQL-standard functions
Date	August 29 20:34:27
Msg-id	CAHyXU0z-aSgsSZu9gKofnUiB2+_XdGvxwj-Lco0pk3bA9kiVNg@mail.gmail.com Whole thread Raw
In response to	Assert single row returning SQL-standard functions ("Joel Jacobson" <joel@compiler.org>)
Responses	Re: Assert single row returning SQL-standard functions Re: Assert single row returning SQL-standard functions
List	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

From: Cary Huang
Date: 29 August, 20:32:20
Subject: Re: Support tid range scan in parallel?

From: "David G. Johnston"
Date: 29 August, 20:44:29
Subject: Re: Assert single row returning SQL-standard functions