From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Subject: | Re: language interface in postgresql |
Date: | 2007-08-18 16:46:30 |
Message-ID: | 46C72266.5040601@cheapcomplexdevices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>> committee, anyway.
>
> I think the aforementioned entities got it wrong where we got it right :)
>
Though Oracle says[1] 'Java-based stored procedures are a standard (ANSI SQL-1999
SQLJ-Part-1 a.k.a. "SQL routines using Java") database-independent alternative
to proprietary procedural extensions to SQL'; so I guess they did both think
of some flexibility in that regard, no?
[1] http://www.oracle.com/technology/sample_code/tech/java/jsp/samples/jwcache/Abstract.html
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-08-18 16:49:09 | Re: SUBSTRING performance for large BYTEA |
Previous Message | Raymond O'Donnell | 2007-08-18 16:36:46 | Re: Finding my database |