INDEX on a composite type
| От | GMail |
|---|---|
| Тема | INDEX on a composite type |
| Дата | |
| Msg-id | 200712192207.32913.vincenzo.romano@gmail.com обсуждение исходный текст |
| Ответы |
Re: INDEX on a composite type
Re: INDEX on a composite type |
| Список | pgsql-general |
Hi all.
When trying to create an index on a composite type, I need to enclose
the columns in paranthesis. Is this normal?
I don't think so as there's no mention in the friendly manual.
An example:
create type atype as (
atext text,
anint int
);
create table atable (
info text,
compo atype
);
create index i_atable_compo on atable(
((compo).atext),((compo).anint)
);
With single parenthesis, as suggested by the friendly manual, I get a
syntax error close to the "."
test=# create index i_atable_compo on atable(
(compo).atext,(compo).anint
);
ERROR: syntax error at or near "."
LINE 2: (compo).atext,(compo).anint
^
--
Vincenzo Romano
Maybe Computers will never become as intelligent as Humans.
Surely they won't ever become so stupid. [VR-1989]
В списке pgsql-general по дате отправления: