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

From Andrew Dunstan
Subject Re: PL/pgSQL 2
Date
Msg-id 5405BE02.5090507@dunslane.net
Whole thread Raw
In response to Re: PL/pgSQL 2  (Ryan Pedela <rpedela@datalanche.com>)
List pgsql-hackers
On 09/02/2014 08:41 AM, Ryan Pedela wrote:
> If PL/Javascript is a serious consideration, how will int64 and 
> numeric be handled?
>
>

Please don't top-post on the PostgreSQL lists. See 
<http://idallen.com/topposting.html>

Unfortunately, I think the short answer is "not very well". In theory we 
cauld add in new types to a Javascript interpreter to handle them, but 
that would still leave you scrambling to handle user defined types.

One of the advantages of plpgsql is that it can handle any Postgres data 
type without having to do anything special.

The truth is that different PLs meet different needs and have different 
strengths and weaknesses.

cheers

andrew







pgsql-hackers by date:

Previous
From: Ryan Pedela
Date:
Subject: Re: PL/pgSQL 2
Next
From: Heikki Linnakangas
Date:
Subject: Re: PL/PgSQL: RAISE and the number of parameters