Received: from gl.aser.de (gl.aser.de [213.252.128.30]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f28DqJx30165 for ; Thu, 8 Mar 2001 08:52:19 -0500 (EST) (envelope-from gcg@gl.aser.de) Received: from pinguin (gcg@node73.dial.Uni-Magdeburg.DE [141.44.160.73]) by gl.aser.de (8.11.2/8.11.2/Debian 8.11.2-1) with SMTP id f28DvEC07572 for ; Thu, 8 Mar 2001 14:57:14 +0100 Content-Type: text/plain; charset="iso-8859-1" From: Christof Glaser Organization: gl.aser software engineering . internet service To: pgsql-sql@postgresql.org Subject: Re: How to build this field Date: Thu, 8 Mar 2001 14:58:09 +0100 X-Mailer: KMail [version 1.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: <0103081452400D.12945@pinguin> Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/172 X-Sequence-Number: 1825 Hi Juerg, > 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 Try the following: SELECT a.a_kurzbez || ' ' || a.a_ausgabenr::text || ' ' || a.a_bundnr::text as metakey, ... remainder as above or, if you need that frequently, create a function: CREATE FUNCTION metakey (text, int4, int4) returns text as ' SELECT $1 || ' ' || text($2) || ' ' || text($3) ' LANGUAGE 'sql'; || is the "concatenate text" operator. Change the param types and cast them as you need. Hope that helps, Christof. > output : > > field : metakey a_kurzbez a_ausgabenr > a_bundnr > > DMD 001 03 DMD 001 > 03 -- gl.aser . software engineering . internet service http://gl.aser.de/ . Planckstraße 7 . D-39104 Magdeburg Tel. +49.391.7 44 77 10 . Fax +49.391.7 44 77 13 . Mobil 0177.77 92 84 3