Thread: Array of char(n) ?

Array of char(n) ?

From
Georges Martin
Date:
What's the syntax for creating an array of char(n) ?

When I try to

  create table example (my_array char(2)[]);

all I got is a

  ERROR:  parser: parse error at or near "["

I looked in manuals, FAQ and lists archive, but found any clues.
Maybe is it so simple I forgot it... :-/

TIA,

Georges Martin

+--------------------------------------------------------------+
 Georges Martin              <mailto:georges.martin@deboeck.be>
+--------------------------------------------------------------+
 Groupe De Boeck s.a.                     phone +32 10 48.25.72
 Fond Jean Pâques 4                         fax +32 10 48.25.19
 B-1348 Louvain-la-Neuve (Belgium)          icq 32724889
+--------------------------------------------------------------+