On 02/09/14 11:56, Pavel Stehule wrote:
2014-09-02 11:50 GMT+02:00 Álvaro Hernández Tortosa <a...@nosys.es
<mailto:a...@nosys.es>>:
On 02/09/14 11:31, Pavel Stehule wrote:
2014-09-02 11:25 GMT+02:00 Álvaro Hernández Tortosa <a...@nosys.es
<mailto:a...@nosys.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