Re: Accommodating alternative column values

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Accommodating alternative column values
Date: 2024-07-03 14:03:13
Message-ID: CAKFQuwYiqUFa1+89CU-EPngG-tMfK4evYCKTOrJRKD8JVSP6kQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, July 3, 2024, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:

>
> I'm not using the proper syntax and the postgres alter table doc has no
> example in the alter column choices.

Simpler syntax forms tend to get skipped over when doing examples.

>
> How do I incorporate the "USING email::..." string?
>

ALTER [ COLUMN ] *column_name* [ SET DATA ] TYPE *data_type* [ COLLATE
*collation* ] [ USING *expression* ]

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-07-03 14:03:42 Re: Accommodating alternative column values
Previous Message Rich Shepard 2024-07-03 13:58:31 Re: Accommodating alternative column values