Change column type macaddr to macaddr[]

From: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Change column type macaddr to macaddr[]
Date: 2017-12-30 23:53:43
Message-ID: 002401d381c9$6cde3d70$469ab850$@1nar.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am using PostgreSQL 9.6.6 on armv8l-unknown-linux-gnueabihf, compiled by
gcc (Raspbian 6.3.0-18+rpi1) 6.3.0 20170516, 32-bit

I have a table with column name mac type macaddr. I need to change it into
array of macaddr ( macaddr[] ) type. Among all others I did try below:

licenses=# alter table licreqm alter column mac type macaddr[] using
mac::macaddr[];
ERROR: cannot cast type macaddr to macaddr[]
LINE 1: ... licreqm alter column mac type macaddr[] using mac::macaddr[...
^
I believe there should be a way, I just do not know it myself. Anyone can
help me?

Thanks & regards,
Ertan Küçükoğlu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-12-30 23:56:13 Re: Change column type macaddr to macaddr[]
Previous Message Stephen Frost 2017-12-30 23:49:31 Re: Sv: Re: Does PostgreSQL check database integrity at startup?