Re: data type change on a view
От | Andreas Kretschmer |
---|---|
Тема | Re: data type change on a view |
Дата | |
Msg-id | 20071212184949.GA22967@KanotixBox обсуждение исходный текст |
Ответ на | Re: data type change on a view ("Scott Marlowe" <scott.marlowe@gmail.com>) |
Ответы |
Re: data type change on a view
|
Список | pgsql-general |
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°
В списке pgsql-general по дате отправления: