On Fri, Aug 25, 2006 at 08:37:19PM -0400, Bruce Momjian wrote: > David Fetter wrote: > > On Fri, Aug 25, 2006 at 07:46:57PM -0400, Bruce Momjian wrote: > > > Here is an new XML section for our SGML documentation. It > > > explains the various XML capabilities, if we support them, and > > > how to use them. > > > > > > Comments? > > > > This looks hauntingly similar to Peter's presentation at the > > I used the XML/SQL and validation part from his talk, but the rest > was from earlier email discussions.
Reuse is good :) > > conference. :) I'd add a http://wiscorp.com/SQLStandards.html to the > > This seems to be the best URL, but it seems too detailed: > > > http://wiscorp.com/H2-2005-197-SC32N1293-WG3_Presentation_for_SC32_20050418.pdf I'd just put the http://wiscorp.com/SQLStandards.html URL in, as it contains several references in varying levels of detail. > > reference section. > > > > Speaking of other parts of the SQL:2003 standard, how about one > > section each that mentions them? There's > > > > Part 4: SQL/PSM (Persistent Stored Modules) > > Part 9: SQL/MED (Management of External Data) (my favorite) > > Part 10: SQL/OLB (Object Language Binding) > > Part 11: SQL/Schemata > > Part 13: SQL/JRT (Java Routines and Types) > > I don't know anything about them. We claim SQL standard compliance, so since those are part of SQL:2003, we probably ought to mention them. SQL/PSM is a programming language that lives inside the database, and DB2 and MySQL have it. SQL/MED lets people talk to other data stores. SQL/OLB appears to be derived from equel, which we have as ecpg. SQL/Schemata contains the information schema. SQL/JRT appears to bear some similarity to PL/Java and PL/J. Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match