Re: data type change on a view

Scott Marlowe <scott.marlowe@gmail.com> schrieb:

> On Dec 12, 2007 12:11 PM, A. Kretschmer
> <andreas.kretschmer@schollglas.com> wrote:
> > Hello @all,
> >
> > i have a question (rot really for myself, a member of ther german forum
> > asks):
> >
> > i have two tables, contains a varchar(N)-column. Now i create a VIEW
> > based on this tables. The resulting view contains now a varchar without
> > length. How can i prevent this? How can i force that the column in the
> > view contains the *exact* typ?
>
> cast it to varchar(8):

As i said in a private mail to Scott (sorry): the suggested way don't
work, at least with 8.1. Maybe this works better in more recent
versions.

But thx for the quick response.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°