Indexing arrays - Mailing list pgsql-general

From Stefano Bargioni
Subject Indexing arrays
Date
Msg-id 3A2E0938.3EA34C80@usc.urbe.it
Whole thread Raw
List pgsql-general
I'd like to index an array. This is my table:
template1=> \d test_array
Table    = test_array
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| name                             | text                             |   var |
| pay_by_quarter                   | int4[]                           |   var |
| schedule                         | text[]                           |   var |
+----------------------------------+----------------------------------+-------+

How can I create an index for schedule? I need to index every occurrence of this array.
Thanks. Stefano
--
Dott. Stefano Bargioni
Biblioteca della Pontificia Universita' della Santa Croce - Roma
<mailto:bargioni@usc.urbe.it>                  <http://www.usc.urbe.it>
Personal web page:    <http://www.usc.urbe.it/html/php.script?bargioni>
--- "Si apud bibliothecam hortulum habes, nihil deerit"  (Cicerone) ---



pgsql-general by date:

Previous
From: Alain Toussaint
Date:
Subject: Re: Clarification
Next
From: Roger Wernersson
Date:
Subject: RE: Clarification