view columm size.....

hi,

i 've create a view
one of the column is the result of col1 || col2.....
col1 is 8 char long
col 2 is 4 char long

but my column view is 254 char long........

so i can't UPDATE a 12 char length col using this view a table because
"Length is not equal to length of the target column"

what should i do to force the length of the view column to 12 char?

thanks

--
______________________________
Arnaud FLORENT
IRIS Technologies

phone: (33) 03 20 65 85 80
fax: (33) 03 20 65 85 81
GSM: (33) 06 15 14 32 90

mailto:aflorent(at)iris-tech(dot)fr
______________________________

FROM <aflorent(at)iris-tech(dot)fr>
RCPT <pgsql-general(at)hub(dot)org>
BODY
Received: from siris.iris-tech.fr(192.168.0.100) by scomm.iris-tech.fr via smap (V2.1)
id xma011429; Thu, 10 Feb 00 10:34:28 +0100
Received: from iris-tech.fr (aflorent(at)afl(dot)iris-tech(dot)fr [192.168.0.5])
by siris.iris-tech.fr (8.9.3/jtpda-5.3) with ESMTP id KAA05811
for <pgsql-general(at)hub(dot)org>; Thu, 10 Feb 2000 10:31:17 +0100
Message-ID: <38A28565(dot)B72BF288(at)iris-tech(dot)fr>
Date: Thu, 10 Feb 2000 10:31:18 +0100
From: Arnaud FLORENT <aflorent(at)iris-tech(dot)fr>
X-Mailer: Mozilla 4.7 [fr] (Win95; I)
X-Accept-Language: fr,en
MIME-Version: 1.0
To: PostgreSQL general ML <pgsql-general(at)hub(dot)org>
Subject: view columm size.....