partial indexes (indices) PostgreSQL 6.3.2 / 6.5.1

Поиск
Список
Период
Сортировка
От Daniel Péder
Тема partial indexes (indices) PostgreSQL 6.3.2 / 6.5.1
Дата
Msg-id 01BF053C.2E0ACE60@Dan
обсуждение исходный текст
Список pgsql-sql
I need to use partial indexes

are they implemented in versions 6.3.2 / 6.5.1 ?
if they are, what's the syntax

example:
table:
grp ... name
A ... john
A ... george
B ... susan
B ... mary

how to create partial index to have seperately indexed groups A and B eg grp='B'

===
what it should be good for ?

I have large table wich is usualy beeng looked up by simple groups. So I need to save resources having the groups
"pre-selected".And, however, sometimes beeing able to lookup the whole table.
 

dan



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

Предыдущее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [SQL] Date type select
Следующее
От: "Hutton, Rob"
Дата:
Сообщение: RE: [SQL] Re: [INTERFACES] JDBC and getting just assigned serial number