Some questions on using arrays.

Поиск
Список
Период
Сортировка
От Ivan Uemlianin
Тема Some questions on using arrays.
Дата
Msg-id 3B5FE71A.5010403@celtic.co.uk
обсуждение исходный текст
Ответы Re: Some questions on using arrays.  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Dear People

I'm finding Postgres very useful with its support for non-atomic
data-types.  I have a couple of questions about setting up and
querying arrays.

If this kind of thing is more for pgsql-novice, please let me know.

Questions refer to the following table.

create table bar ( id serial, links int4[] )

  id |  links
----+---------
   1 | {2,3,4}
   2 | {3,4,5}
   3 | {4,5,6}
   4 | {5,6,7}
   5 | {6}
   6 | {4,5,7}
   7 | {1,3,5}

1. How do I query the contents of an array?  For the example table I'd
    like to say something like 'select * from bar where links contains
    5', but operators like in, @ and ~ don't seem to work.

2. Imagine the table is a directed graph (e.g. a map of one-way
    streets between locations).  I'd like to have each element of links
    to be a reference to id (or a similar field in another table).

Any help or comments appreciated, thank you.

Ivan Uemlianin



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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Info about number of tuples if not use FETCH ALL
Следующее
От: wsheldah@lexmark.com
Дата:
Сообщение: Re: How can I view the definition of an existing trigger?