Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE Query problem - Mailing list pgsql-sql

From Josh Berkus
Subject Re: UPDATE Query problem
Date
Msg-id web-670610@davinci.ethosmedia.com
Whole thread Raw
In response to Re: UPDATE Query problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Tom, Stephan,

Well, you'll be interested to know that Stephan's solution worked for bothPostgreSQL and MS SQL Server ... as far as
parsinggoes.  On PostgreSQL, thequery took 14 minutes to complete.  
 

On MS SQL Server, it never completed at all.  Looks like I will have to take asemi-procedural approach with MS SQL
Serverafter all.  Just another evidenceof the superiority of Postgres ...
 

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco

pgsql-sql by date:

Previous
From: Murray Prior Hobbs
Date:
Subject: Re: pltlc and pltlcu problems
Next
From: Murray Prior Hobbs
Date:
Subject: Re: pltlc and pltlcu problems