Re: Assert single row returning SQL-standard functions

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Joel Jacobson <joel(at)compiler(dot)org>
Cc: Vik Fearing <vik(at)postgresfriends(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Assert single row returning SQL-standard functions
Date: 2025-08-29 16:17:13
Message-ID: CAFj8pRBJ8S9wHsfJ56G+-v6_E5Y8_c8M4Opq6hCJXad8KmBF7w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
>
> I am not too serious now, I am just playing (and I remember this
> discussion many times). We can "theoretically" introduce new keyword
> `EXACT`, that can specify so any DML or SELECT can process or returns just
> one row (or with other clause zero rows)
>
> EXACT ONE SELECT id FROM tab WHERE id = 1;
> EXACT ONE UPDATE ...
> EXACT ONE DELETE ...
> EXACT ONE OR NONE SELECT ...
>

or

EXACT NONE SELECT ...

>
>
>
> /Joel
>>
>>
>>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2025-08-29 16:32:58 Re: aio/README.md comments
Previous Message Pavel Stehule 2025-08-29 16:14:17 Re: Assert single row returning SQL-standard functions