Indexing arrays
От | Stefano Bargioni |
---|---|
Тема | Indexing arrays |
Дата | |
Msg-id | 3A2E0938.3EA34C80@usc.urbe.it обсуждение исходный текст |
Список | 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 по дате отправления: