Fixed Length Arrays - Mailing list pgsql-general

From Arthur M. Kang
Subject Fixed Length Arrays
Date
Msg-id 38B2CCA8.E2F52CB6@levelogic.com
Whole thread Raw
List pgsql-general
Can somebody tell me how to define a fixed length array?  The manual is
pretty sparse on arrays.

I'm trying to create a fixed length boolean array by using:

CREATE TABLE test (apple boolean[5]);

This creates the array, but it is not fixed in length.  Inserting and
retrieving larger arrays (greater than 5) seems to work.  Am I not
seeing how this is supposed to work??

Any enlightenment would be appreciated.  Thanks.

Arthur


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] TRANSACTIONS
Next
From: Jeff MacDonald
Date:
Subject: Re: [GENERAL] Calender