>Alvaro Herrera <alvherre@commandprompt.com> wrote on 02/08/2007 01:58:20 PM: > The "char" type (including quotes) is a very different animal from all > those character types the manual you quote is talking about. "char" is > a single byte, while varchar(1) and all the rest are a single character, > meaning there can be multiple bytes in presence of a multibyte encoding; > so Postgres is forced to use a variable-length structure to store it. > "char" has no such requirement. It's used in the system catalogs as a > "poor man's enum", for example in pg_class.relkind. > > -- > Alvaro Herrera http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc.
Using PGADMINIII I added a column of this type to my database but when I try to update it I get an error.
column: ALTER TABLE datatype ADD COLUMN charflag "char"[]; ALTER TABLE datatype ALTER COLUMN charflag SET STORAGE EXTENDED; COMMENT ON COLUMN datatype.charflag IS 'testing';
update: update datatype set charflag = 'A';
results: ERROR: array value must start with "{" or dimension information SQL state: 22P02
