In message <c22bb40d.0210010624.16284872_at_posting.google.com>, K.Y. Fung
<kyfung_at_hotmail.com> writes
>How to create a view which have different data type and column length
>from the original base table?
>
>For example, the base table consists of:
>
>name character 50
>telephone character 50
>address character 150
>
>the view should have columns:
>
>username character 30
>userphone character 20
>useraddr character varying 100
There is insufficient information to give a complete answer. If your
view has a 100 character column and the source table has a 150 character
column then someone needs to decide on the algorithm for discarding
data. Should you use the leftmost or rightmost characters in the source
data? Should the algorithm return <null> if the source data is more than
100 characters?
--
Bernard Peek
bap_at_shrdlu.com
www.diversebooks.com: SF & Computing book reviews and more.....
In search of cognoscenti
Received on Tue Oct 01 2002 - 18:50:04 CDT
