[HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Tom Lane
Joe, have you heard of a standard called SQL/MED? I came across a description of it the other day. You might think it's got some medical connotation, but actually the acronym is Management of External Data, and what it is is a standard spec for shipping chunks of SQL queries to remote servers.

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Rod Taylor
On Fri, 2002-12-06 at 11:04, Tom Lane wrote: Joe, have you heard of a standard called SQL/MED? I came across a It's that one of the later parts of the SQL 99 spec? Section 9 or thereabouts? -- Rod Taylor [EMAIL PROTECTED] PGP Key: http://www.rbt.ca/rbtpub.asc signature.asc Description:

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Rod Taylor
On Fri, 2002-12-06 at 11:35, Rod Taylor wrote: On Fri, 2002-12-06 at 11:04, Tom Lane wrote: Joe, have you heard of a standard called SQL/MED? I came across a It's that one of the later parts of the SQL 99 spec? Section 9 or thereabouts? Note to self, don't reply to emails and have a

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Joe Conway
Tom Lane wrote: Joe, have you heard of a standard called SQL/MED? I came across a description of it the other day. You might think it's got some medical connotation, but actually the acronym is Management of External Data, and what it is is a standard spec for shipping chunks of SQL queries to

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: Found SQL/MED, Section 21 of ISO 9075-9. That's the old version, though. The new draft is at (digs out article) http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf according to this article, but I'm not having any luck

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Do you think a proposal based on the SQL/MED spec would be entertained for 7.4, or would the release after be a safer bet? The impression I get from this article is that SQL/MED is nontrivial. If you think you can get something useful going for 7.4, step

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Ross J. Reedstrom
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: Found SQL/MED, Section 21 of ISO 9075-9. That's the old version, though. The new draft is at (digs out article) http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Ross J. Reedstrom
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: Found SQL/MED, Section 21 of ISO 9075-9. That's the old version, though. The new draft is at (digs out article) http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002-03.pdf

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Tom Lane
Ross J. Reedstrom [EMAIL PROTECTED] writes: Having pulled that one, I discover it's actually the XML related spec. The MED one is at: ftp://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-09-MED-2002-01.pdf Ah-hah, so the URL in the SIGMOD Record article is just wrong :-(