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