Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0IN2NV77783 for ; Fri, 18 Jan 2002 18:02:23 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 670610 for ; Fri, 18 Jan 2002 15:02:23 -0800 From: "Josh Berkus" Subject: Re: UPDATE Query problem To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Fri, 18 Jan 2002 15:02:23 -0800 Message-ID: In-Reply-To: <3909.1011327258@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200201/227 X-Sequence-Number: 6311 Tom, Stephan, Well, you'll be interested to know that Stephan's solution worked for both PostgreSQL and MS SQL Server ... as far as parsing goes. On PostgreSQL, the query took 14 minutes to complete. On MS SQL Server, it never completed at all. Looks like I will have to take a semi-procedural approach with MS SQL Server after all. Just another evidence of the superiority of Postgres ... -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco