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

From Jan Wieck
Subject Re: PL/pgSQL 2
Date
Msg-id 540649A8.3040408@wi3ck.info
Whole thread Raw
In response to Re: PL/pgSQL 2  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: PL/pgSQL 2
Re: PL/pgSQL 2
List pgsql-hackers
On 09/02/2014 06:41 PM, Joshua D. Drake wrote:
>
> On 09/02/2014 02:47 PM, Álvaro Hernández Tortosa wrote:
>
>>      Yeah, we differ there. I think having an Oracle compatibility layer
>> in PostgreSQL would be the-next-big-thing we could have. Oracle is has
>> orders of magnitude bigger user base than postgres has; and having the
>> ability to attract them would bring us many many more users which, in
>> turn, would benefit us all very significantly.
>>
>>      It would be my #1 priority to do in postgres (but yes, I know
>> -guess- how hard and what resources that would require). But dreaming is
>> free :)
>
> Oracle compatibility certainly has merit, I just don't see it as useful
> for core. I would be far more interested in MSSQL compatibility
> honestly. That said, Postgres itself is a rockstar and I think we can
> make our own case without having to copy others.

PL/pgSQL's syntax was modelled to look like PL/SQL. Which is a Ada/COBOL 
lookalike.

Instead of trying to mimic what it was or a T-SQL thing instead ... 
maybe it is time to come up with a true PostgreSQL specific PL for a change?

Just for the sake of being something new, and not a copy of some old 
opossum, that's rotting like road kill on the side of the highway for a 
decade already.


Jan

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



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: why after increase the hash table partitions, TPMC decrease
Next
From: Andrew Dunstan
Date:
Subject: Re: PL/pgSQL 2