Re: proposal: plpgsql - Assert statement

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: proposal: plpgsql - Assert statement
Date: 2014-11-18 21:11:48
Message-ID: CAFj8pRCFuEZGvprEVEfN2+fHYbb1GA8P7mnQibna77+s8J5Syw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2014-11-18 21:27 GMT+01:00 Andrew Dunstan <andrew(at)dunslane(dot)net>:

>
> On 11/18/2014 02:53 PM, Jim Nasby wrote:
>
>> On 11/18/14, 9:31 AM, Andrew Dunstan wrote:
>>
>>>
>>> Frankly, I find this whole proposal, and all the suggested alternatives,
>>> somewhat ill-conceived. PLPGSQL is a wordy language. If you want something
>>> more terse, use something else. Adding these sorts of syntactic sugar warts
>>> onto the language doesn't seem like a terribly good way to proceed.
>>>
>>
>> Such as?
>>
>> The enormous advantage of plpgsql is how easy it is to run SQL. Every
>> other PL I've looked at makes that WAY harder. And that's assuming you're
>> in an environment where you can install another PL.
>>
>> And honestly, I've never really found plpgsql to be terribly wordy except
>> in a few cases ("assert" being one of them). My general experience has been
>> that when I'm doing an IF (other than assert), I'm doing multiple things in
>> the IF block, so it's really not that big a deal.
>>
>>
>
> I frequently write one-statement bodies of IF statements. To me that's not
> a big deal either :-)
>

anybody did it, but it doesn't need so it is perfect :) I understand well
to Jim' feeling.

I am looking to Ada 2005 language ... a design of RAISE WITH shows so RAISE
statement is extensible in Ada too. Sure - we can live without it, but I
don't think so we do some wrong with introduction RAISE WHEN and I am sure,
so a live with this feature can be more fun for someone, who intensive use
this pattern.

>
> cheers
>
> andrew
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2014-11-18 21:19:40 Re: proposal: plpgsql - Assert statement
Previous Message Jeff Janes 2014-11-18 20:41:28 pg_test_fsync file descriptor leak