Re: [GENERAL] data type change on a view

2007-12-13 Thread Andreas Kretschmer
Tom Lane <[EMAIL PROTECTED]> schrieb: > Andreas Kretschmer <[EMAIL PROTECTED]> writes: > >> 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. > > Yes, it works a lot

Re: [GENERAL] data type change on a view

2007-12-12 Thread Tom Lane
Andreas Kretschmer <[EMAIL PROTECTED]> writes: >> 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. Yes, it works a lot better in 8.2: http://archives.postgresql.org/pgsql-co

Re: [GENERAL] data type change on a view

2007-12-12 Thread Andreas Kretschmer
Scott Marlowe <[EMAIL PROTECTED]> schrieb: > On Dec 12, 2007 12:11 PM, A. Kretschmer > <[EMAIL PROTECTED]> 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

Re: [GENERAL] data type change on a view

2007-12-12 Thread Scott Marlowe
On Dec 12, 2007 12:11 PM, A. Kretschmer <[EMAIL PROTECTED]> 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 va

[GENERAL] data type change on a view

2007-12-12 Thread A. Kretschmer
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 i