Horton
Menu

Re: UPDATE Query problem

Josh Berkus <josh@agliodbs.com>

View thread
From: "Josh Berkus" <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, "Josh Berkus" <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Date: 2002-01-18T05:18:27Z
Lists: pgsql-hackers 
Tom,

> Oh, I'm sorry: forgot the extra qualification on the innermost SELECT:
> 
>  AND oldest.timestamp < history.timestamp

Hmmm ... I'll try both solutions tommorrow.  That is, I'll see if they port
 across databases ...
 
> > Yeah, you guessed it ... MS SQL Server 7.
> 
> I dunno, how good is SQL Server on subselects?

Not very good.  A lot of stuff, like subselects in the SELECT line, is not
 supported.    And MS has gotten further from the SQL standard with each update
 since SQL Server 7.0 ...

-Josh


______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