Search Postgresql Archives

Re: Accommodating alternative column values

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



The USING phrase basically answers the question how do I convert an existing value of the old type to the new type.

On Wed, Jul 3, 2024 at 4:03 PM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
On Wed, 3 Jul 2024, Rich Shepard wrote:

> What I've tried:
> bustrac=# alter table people alter column email set data type varchar(64) [];
> ERROR:  column "email" cannot be cast automatically to type character
> varying[]
> HINT:  You might need to specify "USING email::character varying(64)[]".

What I forgot to mention is that the current datatype is varchar(64) and I
want to make it an array.

Rich



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux