Re: PL/pgSQL 2

On 02/09/14 11:56, Pavel Stehule wrote:
>
>
>
> 2014-09-02 11:50 GMT+02:00 Álvaro Hernández Tortosa <aht(at)nosys(dot)es
> <mailto:aht(at)nosys(dot)es>>:
>
>
> On 02/09/14 11:31, Pavel Stehule wrote:
>>
>>
>>
>> 2014-09-02 11:25 GMT+02:00 Álvaro Hernández Tortosa <aht(at)nosys(dot)es
>> <mailto:aht(at)nosys(dot)es>>:
>>
>>
>> On 02/09/14 05:24, Craig Ringer wrote:
>>
>> I couldn't disagree more.
>>
>> If we were to implement anything, it'd be PL/PSM
>> (http://en.wikipedia.org/wiki/SQL/PSM). I'm sure it's as
>> bizarre and
>> quirky as anything else the SQL committee has brought
>> forth, but it's at
>> least a standard(ish) language.
>>
>> So we'd choose a bizarre and quirky language instead of
>> anything better just because it's standard. I'm sure current
>> and prospective users will surely prefer a bizarre and quirky
>> language that is standard approved, rather than a modern,
>> comfortable, easy-to-use, that is not embodied by the ISO. No
>> doubt ^_^
>>
>>
>> SQL/PSM is used in >>>DB2<<<, >>>Sybase Anywhere<<<, MySQL,
>
> That's a way better argument that it's standard :)))
>
> Still, I think postgres is in the position of attracting more
> Oracle than DB2+Sybase+MySQL users
>
>
> Not all can be happy :)
>
> We can implement SQL/PSM in conformity with ANSI SQL. But we cannot to
> implement PL/SQL be in 20% compatible with oracle - Aggegates, pipe
> functions, collections, without rewriting lot code.
>
> I remember lot of projects that promises compatibility with Oracle
> based on Firebird -- all are dead. Now situation is little bit
> different - there are big press for migration from Oracle, but Oracle
> is too big monster.

OK. Thanks for all the info I was missing about this complexity, I
see that it goes well beyond the syntax thing.

However, I'd insist that this should be IMHO a big priority, and
I'd set it as a long-term goal. Even better if it could have a phased
approach, that would make a lot of people happier (targeting the most
used functionality). I'm sure pushing us to implement those missing
features would also be really good, too.

In the meantime, having another language (probably not plpgsql2)
that is modern and appealing to many users would be a very nice win.

Regards,

Álvaro