Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
| От | MargaretGillon@chromalloy.com |
|---|---|
| Тема | Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9 |
| Дата | |
| Msg-id | OF2E2627A3.47B95407-ON8825727C.007C295D-8825727C.007C7D42@CHROMALLOY.COM обсуждение исходный текст |
| Ответ на | Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9 (Alvaro Herrera <alvherre@commandprompt.com>) |
| Ответы |
Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
|
| Список | pgsql-general |
>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
Margaret Gillon
В списке pgsql-general по дате отправления: