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@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005