Ühel kenal päeval, T, 2006-07-11 kell 17:34, kirjutas Thomas Hallgren: > Josh Berkus wrote: > > Tom, > >
> >> IOW pljava is (already) bigger than the other four PLs put together. > > > > That is odd. Thomas? > > > It's not that odd really: > > 1. the mapping is strongly typed, i.e. each scalar type in PostgreSQL > has a set of functions that maps it to the correct primitive in Java > (int4 is a java int, double precision is a double etc.). PL/Java will > resort to string coercion only when no other option is left. > 2. a type mapping is provided for *all* types. Scalar, composite, > pseudo, array types, and result sets. > 3. new Java mappings can be created on the fly. Both for scalar and > composite types. > 4. you can create new scalar types in PostgreSQL that uses IO functions > written in Java. Maybe this functionality could be lifted out of PL/Java and made available to all PL-s ? At least at some API level. -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly