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@iris-tech.fr
______________________________
FROM <aflorent@iris-tech.fr>
RCPT <pgsql-general@hub.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@afl.iris-tech.fr [192.168.0.5])
by siris.iris-tech.fr (8.9.3/jtpda-5.3) with ESMTP id KAA05811
for <pgsql-general@hub.org>; Thu, 10 Feb 2000 10:31:17 +0100
Message-ID: <38A28565.B72BF288@iris-tech.fr>
Date: Thu, 10 Feb 2000 10:31:18 +0100
From: Arnaud FLORENT <aflorent@iris-tech.fr>
X-Mailer: Mozilla 4.7 [fr] (Win95; I)
X-Accept-Language: fr,en
MIME-Version: 1.0
To: PostgreSQL general ML <pgsql-general@hub.org>
Subject: view columm size.....