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

From Jan Wieck
Subject Re: PL/pgSQL 2
Date
Msg-id 54063480.9010401@wi3ck.info
Whole thread Raw
In response to Re: PL/pgSQL 2  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 09/01/2014 09:06 PM, Andrew Dunstan wrote:
>
> On 09/01/2014 08:09 PM, Neil Tiffin wrote:
> The docs also tell you how to avoid having to do this, using dollar quoting.
>
>
>>
>> That should be enough alone to suggest postgreSQL start working on a modern, in core, fast, fully supported
language. Of course PL/pgSQL works, but so did one-line 5k perl programs that nobody likes today.  Everything can be
donein assembler, but no one suggests that today.  Today, it is all about programmer productivity.  PL/pgSQL has a lot
ofunnecessary stuff that sucks the life out of programmer productivity.  And this should be very much a concern of the
professionalsthat support PostgreSQL
 
>>
>> For example:
>>
>> DECLARE
>> declarations
>> BEGIN
>> statements
>> END
>>
>> This looks a lot like COBOL or Pascal, and today is mostly unnecessary.
>
> It looks like Ada, and that's not an accident. (Nor is it a bad thing.)

First of all it is

[DECLARE
declarations]
BEGIN
statements
END;

Second "statements" includes the whole definition above as a "statement" 
and controls identifier visibility and such compatible to PL/SQL.

You want to lose that? Not such a great idea, IMHO.


Jan


-- 
Jan Wieck
Senior Software Engineer
http://slony.info



pgsql-hackers by date:

Previous
From: Joel Jacobson
Date:
Subject: Re: PL/pgSQL 2
Next
From: Tom Lane
Date:
Subject: Re: Escaping from blocked send() reprised.