Re: Accommodating alternative column values

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Accommodating alternative column values
Date: 2024-07-03 14:03:42
Message-ID: 3eb9a2d3-28c-9066-d3b5-fd6cca32af9@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2024-07-03 14:04:21 Re: Accommodating alternative column values
Previous Message David G. Johnston 2024-07-03 14:03:13 Re: Accommodating alternative column values