| From: | Stefano Bargioni <bargioni(at)usc(dot)urbe(dot)it> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Indexing arrays |
| Date: | 2000-12-06 09:39:04 |
| Message-ID: | 3A2E0938.3EA34C80@usc.urbe.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)usc(dot)urbe(dot)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) ---
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Wernersson | 2000-12-06 09:43:55 | RE: Clarification |
| Previous Message | Bernard Frankpitt | 2000-12-06 07:43:05 | Re: [GENERAL] RE: Indexing for geographic objects? |