Re: data type change on a view

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: data type change on a view
Date: 2007-12-13 20:27:24
Message-ID: 20071213202723.GA496@KanotixBox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> schrieb:

> Andreas Kretschmer <akretschmer(at)spamfence(dot)net> 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-committers/2006-08/msg00222.php

Thx you very much for the answer and the link.

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°

In response to

Browse pgsql-general by date

  From Date Subject
Next Message André Volpato 2007-12-13 20:36:44 Re: Hash join in 8.3
Previous Message Heikki Linnakangas 2007-12-13 20:25:07 Re: [GENERAL] Slow PITR restore