[DOCS] 'FOUND' keyword not found in index (pg8.2)

2007-02-12 Thread Mario Splivalo
Hi. I was told earlier to 'report' those kind of things on this
mailinglist, if I'm making a mistake here I appologize, and I'd
appreciate guidelines for future 'reportings'.

So, there goes:

In PostgreSQL plpgsql language there is special variable calles FOUND,
which is described here:
http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

Still, there is no mention of it in postgresql Index:
http://www.postgresql.org/docs/8.2/interactive/bookindex.html

Am I missing something here, or 'FOUND' keyword should be enlisted in
Index?

Mario


---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [DOCS] 'FOUND' keyword not found in index (pg8.2)

2007-02-12 Thread Tom Lane
Mario Splivalo <[EMAIL PROTECTED]> writes:
> Am I missing something here, or 'FOUND' keyword should be enlisted in
> Index?

Probably.  The indexing of the PL chapters seems pretty weak in general;
anyone want to submit a patch?

regards, tom lane

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match