On 9/2/14 11:04 AM, Pavel Stehule wrote:
It is relatively natural and we use similar construct in CONTINUE statement.
2. What can be next? We can implement some idiom (shortcut) for GET
DIAGNOSTICS
DELETE FROM tab WHERE xx = somevar;
RAISE EXCEPTION 'some' WHEN AFFECTED_ROW_COUNT <> 1;
Yes, a special variable would be closer to how I would prefer to access
the row count.
3. What next? Maybe some notations -
-- ** ensure_exact_one_row
DELETE FROM tab WHERE xx = somevar;
I really, really don't like the idea of turning regular SQL statements
into something slightly different based on comments around (or "inside")
the query.
.marko
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers