SubQueries

From: The Web Administrator <wwwadmin(at)wizard(dot)ca>
To: PGsql <pgsql-sql(at)postgreSQL(dot)org>
Subject: SubQueries
Date: 1998-07-14 04:55:38
Message-ID: 35AAE4CA.896AF6FE@wizard.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Aaaargg.. sub queries aren't implemented?
Any quick ideas how to get around this ..
UPDATE table SET time_out='now'
WHERE time_in=(SELECT max(time_in) FROM table
WHERE
account_name='sparky')
AND account_name='sparky';

--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Michael - System Administrator Working in Cheap Canadian
Dollars
Unix Administration - WebSite Hosting - Network Services - Programming
Wizard Internet Services - TechnoWizard Computers - Wizard Tower
TechnoServices
------------------------------------------------------------------------------

(604) 589-0037 Beautiful British Columbia, Canada
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1998-07-14 05:01:35 Re: [SQL] SubQueries
Previous Message Marc Howard Zuckman 1998-07-13 23:56:27 Re: [SQL] case-insensitive lookups...