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.
|
| Список | 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 по дате отправления: