Re: Assert single row returning SQL-standard functions

On Fri, Aug 29, 2025 at 11:45 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Fri, Aug 29, 2025 at 10:34 AM Merlin Moncure <mmoncure(at)gmail(dot)com>
> wrote:
>
>> 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
>>
>
> This example seems unrelated to the point being made.
>

sure, it's off topic to the main question, but it was noted in the intro.

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

roger.

merlin