pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpartial indexes (indices)
4+ messages / 3 participants
[nested] [flat]
* partial indexes (indices)
@ 1999-09-23 16:28 Daniel Péder <dpeder@infoset.cz>
0 siblings, 1 reply; 4+ messages in thread
From: Daniel Péder @ 1999-09-23 16:28 UTC (permalink / raw)
To: pgsql-sql@hub.org <pgsql-sql@hub.org>
does anybody know anything about subject?
any hint where can I find documentation ( in standard PSQL manual pages is only short item withou any syntax description)
--
Daniel Peder
dpeder@infoset.cz
http://shop.culture.cz
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] partial indexes (indices)
@ 1999-09-23 17:02 Bruce Momjian <maillist@candle.pha.pa.us>
parent: Daniel Péder <dpeder@infoset.cz>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 1999-09-23 17:02 UTC (permalink / raw)
To: [Daniel P_der] <dpeder@infoset.cz>; +Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>
> does anybody know anything about subject?
> any hint where can I find documentation ( in standard PSQL manual pages is only short item withou any syntax description)
>
> --
Allows you to index only part of a table. Don't know any more.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [SQL] partial indexes (indices)
@ 1999-09-23 17:10 Daniel Péder <dpeder@infoset.cz>
0 siblings, 1 reply; 4+ messages in thread
From: Daniel Péder @ 1999-09-23 17:10 UTC (permalink / raw)
To: pgsql-sql@hub.org <pgsql-sql@hub.org>
YES!
that's what I'am looking for. But does anybody know HOW ?
-----Original Message-----
> does anybody know anything about subject?
> any hint where can I find documentation ( in standard PSQL manual pages is only short item withou any syntax description)
>
> --
Allows you to index only part of a table. Don't know any more.
--
Dan Peder
dpeder@infoset.cz
http://shop.culture.cz
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] partial indexes (indices)
@ 1999-09-23 21:34 Tom Lane <tgl@sss.pgh.pa.us>
parent: Daniel Péder <dpeder@infoset.cz>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 1999-09-23 21:34 UTC (permalink / raw)
To: Daniel Péder <dpeder@infoset.cz>; +Cc: pgsql-sql@hub.org <pgsql-sql@hub.org>; pgsql-hackers@postgreSQL.org
=?iso-8859-2?Q?Daniel_P=E9der?= <dpeder@infoset.cz> writes:
> YES!
> that's what I'am looking for. But does anybody know HOW ?
> Allows you to index only part of a table. Don't know any more.
It seems to be disabled in gram.y for some reason (no WHERE clause in
CREATE INDEX anymore), which is odd since there's still an awful lot of
code to support the feature elsewhere.
Anyone know who took this out and why?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-09-23 21:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-23 16:28 partial indexes (indices) Daniel Péder <dpeder@infoset.cz>
1999-09-23 17:02 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-09-23 17:10 RE: [SQL] partial indexes (indices) Daniel Péder <dpeder@infoset.cz>
1999-09-23 21:34 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox