Received: from post.gateone.com (qmailr@post.gateone.com [204.244.205.25]) by hub.org (8.8.8/8.7.5) with SMTP id AAA13890 for ; Tue, 14 Jul 1998 00:55:28 -0400 (EDT) Received: (qmail 17525 invoked from network); 14 Jul 1998 04:55:25 -0000 Received: from trevor.gateone.com (HELO wizard.ca) (204.244.205.12) by mail.gateone.com with SMTP; 14 Jul 1998 04:55:25 -0000 Message-ID: <35AAE4CA.896AF6FE@wizard.ca> Date: Mon, 13 Jul 1998 21:55:38 -0700 From: The Web Administrator Reply-To: wwwadmin@wizard.ca X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: PGsql Subject: SubQueries Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++