view columm size..... - Mailing list pgsql-general

From Arnaud FLORENT
Subject view columm size.....
Date
Msg-id 38A28565.B72BF288@iris-tech.fr
Whole thread Raw
Responses Re: [GENERAL] view columm size.....
List pgsql-general
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.....

pgsql-general by date:

Previous
From: "Sanjay Minni"
Date:
Subject: features of PGSQL
Next
From: "José A. Navarro"
Date:
Subject: subscribe pgsql-general