From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
---|---|
To: | Arnaud FLORENT <aflorent(at)iris-tech(dot)fr> |
Cc: | PostgreSQL general ML <pgsql-general(at)hub(dot)org> |
Subject: | Re: [GENERAL] view columm size..... |
Date: | 2000-02-10 16:01:50 |
Message-ID: | 20000210100150.B8184@rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Feb 10, 2000 at 10:31:18AM +0100, Arnaud FLORENT wrote:
> 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?
>
Hmm, try something like:
substr("ColView",1,12)
That should give you the first 12 characters, i.e. all of them. See if
the UPDATE likes it.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-02-10 16:02:19 | Re: [GENERAL] features of PGSQL |
Previous Message | Daniel Forsyth | 2000-02-10 15:49:57 | Quick Varchar Question |