pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
partial indexes (indices)
4+ messages / 3 participants
[nested] [flat]

* partial indexes (indices)
@ 1999-09-23 16:28 Daniel Péder <dpeder@infoset.cz>
  1999-09-23 17:02 ` Re: [SQL] partial indexes (indices) Bruce Momjian <maillist@candle.pha.pa.us>
  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 16:28 partial indexes (indices) Daniel Péder <dpeder@infoset.cz>
@ 1999-09-23 17:02 ` Bruce Momjian <maillist@candle.pha.pa.us>
  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>
  1999-09-23 21:34 ` Re: [SQL] partial indexes (indices) Tom Lane <tgl@sss.pgh.pa.us>
  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 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>
  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