Thread: Indexing arrays

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) ---