Received: from srvlnx02.pup.ch ([212.28.153.195]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2888mx91344 for ; Thu, 8 Mar 2001 03:08:50 -0500 (EST) (envelope-from juerg.rietmann@pup.ch) Subject: How to build this field To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: juerg.rietmann@pup.ch Date: Thu, 8 Mar 2001 09:10:59 +0100 X-MIMETrack: Serialize by Router on srvlnx02/Pup/ch(Release 5.0.5 |September 22, 2000) at 03/08/2001 09:11:09 AM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Archive-Number: 200103/170 X-Sequence-Number: 1823 Hi everybody I need to build an additional field (metakey) out of three fields in the table. SELECT a.a_kurzbez, a.a_ausgabenr, a.a_bundnr, a.a_nr, a.a_z_blaenge, a.a_z_laenge, a.a_z_umfang FROM auftrag a should be changed to something like SELECT (a.a_kurzbez + a.a_ausgabenr + a.a_bundnr) as metakey, a.a_kurzbez, a.a_ausgabenr, a.a_bundnr, a.a_nr, a.a_z_blaenge, a.a_z_laenge, a.a_z_umfang FROM auftrag a output : field : metakey a_kurzbez a_ausgabenr a_bundnr DMD 001 03 DMD 001 03 Thanks for any help ... jr ============================================ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ============================================