Re: Bug in predicate indexes?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug in predicate indexes?
Date: 2005-11-22 03:31:53
Message-ID: 43829129.3030003@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> <(integer,bigint)
> <(bigint,integer)
> <(smallint,integer)
> <(integer,smallint)
> <(real,double precision)
> <(double precision,real)
> <(smallint,bigint)
> <(bigint,smallint)
> <(date,timestamp without time zone)
> <(date,timestamp with time zone)
> <(timestamp without time zone,date)
> <(timestamp with time zone,date)
> <(timestamp without time zone,timestamp with time zone)
> <(timestamp with time zone,timestamp without time zone)
>
>I'm not sure this is worth documenting given that it's likely to change
>by 8.2 anyway.
>
>
I think that we should be explicit as possible. This is a limitation
that effects every release
that is currently supported by the community. Which is as least 7.4,
8.0, 8.1 and possibly
7.3 (did we ever come to conclusion on that?).

The limitation should be addressed and patched to each documentation set.

Sincerely,

Joshua D. Drake

> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2005-11-22 03:59:46 Re: Use of 8192 as BLCKSZ in xlog.c
Previous Message Christopher Kings-Lynne 2005-11-22 03:31:14 Re: Are NULLs in Arrays compressed?