From: webmaster <webmaster@tony.cz>
To: pgsql-sql@postgresql.org
Subject: String concat operator???
Date: Wed, 30 Jun 1999 15:16:31 +0200
Message-ID: <99063015213102.00441@localhost.localdomain> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: webmaster@tony.cz
Subject: Re: String concat operator???
In-Reply-To: <99063015213102.00441@localhost.localdomain>
References: <99063015213102.00441@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox