Received: from relay02.esat.net (relay02.esat.net [192.111.39.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e59AGHT45599 for ; Fri, 9 Jun 2000 06:16:17 -0400 (EDT) Received: from (ebeon.com) [193.120.161.91] by relay02.esat.net with esmtp id 130Lpo-00009n-00; Fri, 09 Jun 2000 11:16:16 +0100 Message-ID: <3940D29E.1B4B6B8D@ebeon.com> Date: Fri, 09 Jun 2000 12:18:54 +0100 From: Niall Smart X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12 i386) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Something I'd like to try... Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/103 Hi, I just noticed that postgres doesn't totally support column aliases on UPDATE statements, for example UPDATE EMPLOYEES SET OFFICE_PHONE = UU.OFFICE_PHONE, MOBILE_PHONE = UU.MOBILE_PHONE, OFFICE_CD = UU.OFFICE_CD, ABOUT_ME = UU.ABOUT_ME FROM UNCONFIRMED_UPDATES UU WHERE EMPLOYEES.EMPLOYEE_ID = UU.EMPLOYEE_ID AND UU.UPDATE_ID = 'HJhjaJ023J19KJAqp' It is not currently possible to alias EMPLOYEES so that the test can become E.EMPLOYEE_ID = UU.EMPLOYEE_ID Do the guru's think that this would be hard to add? Also, is it desirable? -- Niall Smart email: niall.smart@ebeon.com phone: (087) 8052390