X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A0EC1D1B21B for ; Thu, 20 May 2004 12:59:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 03775-08 for ; Thu, 20 May 2004 12:58:40 -0300 (ADT) Received: from kcmailoutext1.ameritrade.com (kcmailoutext1.ameritrade.com [198.200.171.236]) by svr1.postgresql.org (Postfix) with ESMTP id D6417D1B19C for ; Thu, 20 May 2004 12:58:36 -0300 (ADT) Received: from kscdcmailgw5.prod-am.ameritrade.com ([10.29.26.242]) by kscdcsmtpout3.ameritrade.com with SMTP; Thu, 20 May 2004 10:58:35 -0500 Received: from scsdcmail1.prod-am.ameritrade.com ([10.142.211.13]) by kscdcmailgw5.prod-am.ameritrade.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 20 May 2004 10:58:35 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C43E83.4E5242FA" Subject: XML data field Date: Thu, 20 May 2004 11:58:34 -0400 Message-ID: <2898C2526ECBEB448D434BA1F302790902E93CF1@scsdcmail1.ameritrade.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: XML data field Thread-Index: AcQ+gycD8UoLAq2NRQO91kd3VBwJZA== From: To: X-OriginalArrivalTime: 20 May 2004 15:58:35.0485 (UTC) FILETIME=[4EAD88D0:01C43E83] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200405/191 X-Sequence-Number: 17905 This is a multi-part message in MIME format. ------_=_NextPart_001_01C43E83.4E5242FA Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Does anyone have any experience in retrieving and formatting an XML data from a field using pgSQL? Are there any system stored procs that could reformat the XML elements or just retrieve the elements needed? =20 Thanks! - Lily Anne=20 ------_=_NextPart_001_01C43E83.4E5242FA Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Does anyone have any experience in retrieving and format= ting an XML data from a field using pgSQL? Are there= any system stored procs that could reformat the XML elements or just retrieve the elements needed?

 

Thanks!

- Lily Anne

------_=_NextPart_001_01C43E83.4E5242FA--