Horton

Re: Assert single row returning SQL-standard functions

Pavel Stehule <pavel.stehule@gmail.com>

View thread
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Joel Jacobson <joel@compiler.org>
Cc: Vik Fearing <vik@postgresfriends.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-29T16:17:13Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add error_on_null(), checking if the input is the null value

  2. SQL-standard function body

>
>
> 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
>>
>>
>>