Re: language interface in postgresql - Mailing list pgsql-general

From Tom Lane
Subject Re: language interface in postgresql
Date
Msg-id 23714.1187152576@sss.pgh.pa.us
Whole thread Raw
In response to Re: language interface in postgresql  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Responses Re: language interface in postgresql  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> Let me fine tune my question here. What I mean to say is the way we can
> write stored procedures in C, perl etc in Postgres specifying the language
> parameter at the end of stored procedure, compared to that, in SQL Server
> 2000 I've seen SP writing in pure SQL only.

Ah.  I thought you were talking about client interface libraries in
different languages, which are surely a dime a dozen.  As far as
server-side functions go, we might be unique in offering so many
languages to work in.  I think we probably are unique in being so
aggressively agnostic about what the function language is.  That's
not necessarily all good, as it's driven us to invent curiosities
like dollar-quoting to avoid having to mesh lexical details of the
function language and the outer SQL language.

            regards, tom lane

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Blobs in Postgresql
Next
From: "Trevor Talbot"
Date:
Subject: Re: language interface in postgresql