Re: INDEX on a composite type

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: INDEX on a composite type
Дата
Msg-id 20071219212725.GB24426@svana.org
обсуждение исходный текст
Ответ на INDEX on a composite type  (GMail <vincenzo.romano@gmail.com>)
Список pgsql-general
On Wed, Dec 19, 2007 at 10:07:32PM +0100, GMail wrote:
> 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.

I beleive it says somewhere that anything except straight column names
need parenthesis. What you have is an expression and thus it needs
them.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Partitioned tables & Slony
Следующее
От: Colin Wetherbee
Дата:
Сообщение: Re: INDEX on a composite type