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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to