Postgres Pro
Downloads
Home   >   mailing lists

Re: How to Alter tables with ARRAY? Help PLease - Mailing list pgsql-general

From Tom Lane
Subject Re: How to Alter tables with ARRAY? Help PLease
Date
Msg-id 15116.991749466@sss.pgh.pa.us
Whole thread Raw
In response to How to Alter tables with ARRAY? Help PLease  (Igor <dbmanager@osb368.nnov.ru>)
Responses Re[2]: How to Alter tables with ARRAY? Help PLease  (Igor <dbmanager@osb368.nnov.ru>)
List pgsql-general
Tree view 
Igor <dbmanager@osb368.nnov.ru> writes:
> Tell me please, how to alter tables with arrays
> (in other words - to change the dimension of array )

Just assign a new array value to the column.  PG doesn't actually
consider the dimensionality of an array to be part of the type
specification; any size array will be accepted.

            regards, tom lane

pgsql-general by date:

Previous
From: Francesco Casadei
Date:
Subject: return value of a version-1 C function (Solved)
Next
From: Evelio Martinez
Date:
Subject: Postgresql and W98