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
