Request a Demo
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: Assert single row returning SQL-standard functions
Date
Msg-id CAFj8pRBJ8S9wHsfJ56G+-v6_E5Y8_c8M4Opq6hCJXad8KmBF7w@mail.gmail.com
Whole thread Raw
In response to Re: Assert single row returning SQL-standard functions  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Assert single row returning SQL-standard functions
List pgsql-hackers
Tree view

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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Assert single row returning SQL-standard functions
Next
From: Andres Freund
Date:
Subject: Re: aio/README.md comments