Re: [GENERAL] language interface in postgresql

2007-08-18 Thread Ron Mayer
David Fetter wrote: >> Dollar-quoting is a cute technical solution to that, but you can't >> deny that it's simpler if you just restrict the function language to >> be SQL-ish so that CREATE FUNCTION can parse it without any >> interesting quoting rules. So sayeth Oracle and the SQL standards >> c

Re: [GENERAL] language interface in postgresql

2007-08-15 Thread David Fetter
On Wed, Aug 15, 2007 at 01:10:15AM -0400, Tom Lane wrote: > "Scott Marlowe" <[EMAIL PROTECTED]> writes: > > On 8/14/07, Tom Lane <[EMAIL PROTECTED]> wrote: > >> ... I think we probably are unique in being so aggressively > >> agnostic about what the function language is. That's not > >> necessari

Re: [GENERAL] language interface in postgresql

2007-08-15 Thread Josh Tolley
On 8/15/07, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Trevor Talbot wrote: > > On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: > > > >> 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 langu

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Magnus Hagander
Trevor Talbot wrote: > On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: > >> 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 tha

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On 8/14/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> ... 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-

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Scott Marlowe
On 8/14/07, Tom Lane <[EMAIL PROTECTED]> wrote: > "Jasbinder Singh Bali" <[EMAIL PROTECTED]> 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 procedur

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Trevor Talbot
On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: > 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

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Tom Lane
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> 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 w

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Jasbinder Singh Bali
Hi, 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. Can you write Stored Procedure

Re: [GENERAL] language interface in postgresql

2007-08-14 Thread Trevor Talbot
On 8/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: > I was wondering if any other database has language interface for different > programing languages such as C , perl , python etc the way postgresql has. Assuming you mean stored procedures, Microsoft's SQL Server hosts the CLR, which me