Re: PL/pgSQL 2 - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: PL/pgSQL 2
Date
Msg-id 54058F0F.7030205@joh.to
Whole thread Raw
In response to Re: PL/pgSQL 2  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: PL/pgSQL 2  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PL/pgSQL 2
Next
From: Mark Kirkwood
Date:
Subject: Re: PL/pgSQL 2