Received: from ns.silesnet.cz (IDENT:root@ns.silesnet.cz [194.228.108.19]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA12524 for ; Wed, 30 Jun 1999 09:25:10 -0400 (EDT) (envelope-from webmaster@tony.cz) Received: from localhost.localdomain (ct2.silesnet.cz [194.228.108.2]) by ns.silesnet.cz (8.8.7/8.8.7) with SMTP id PAA05140 for ; Wed, 30 Jun 1999 15:25:06 +0200 From: webmaster Reply-To: webmaster@tony.cz To: pgsql-sql@postgresql.org Subject: String concat operator??? Date: Wed, 30 Jun 1999 15:16:31 +0200 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <99063015213102.00441@localhost.localdomain> Content-Transfer-Encoding: 8bit I'm trying to update a character field by foll. query: update temp_kat set id_look = substr(ident,1,6) || '-' || substr(ident,7,7) where from_kat='P'; Both id_look and ident are varchars.. So what's wrong with || operator? There is an error parsing the querry near || ... Who is stupid? Me, or postgresql 6.4.2 :) ? It look like legal expression for me... -- Michal Samek, Tony distribuce s.r.o. webmaster@tony.cz (++420659/321350) ICQ: 38607210