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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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... |