Re: Assert single row returning SQL-standard functions

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Joel Jacobson <joel(at)compiler(dot)org>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Assert single row returning SQL-standard functions
Date: 2025-08-29 17:34:27
Message-ID: CAHyXU0z-aSgsSZu9gKofnUiB2+_XdGvxwj-Lco0pk3bA9kiVNg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 29, 2025 at 1:03 AM Joel Jacobson <joel(at)compiler(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2025-08-29 17:44:29 Re: Assert single row returning SQL-standard functions
Previous Message Cary Huang 2025-08-29 17:32:20 Re: Support tid range scan in parallel?