Re: Ad Hoc Indexes

Justin wrote:
> Now for my question It does not appear PostgreSQL does not have an Ad
> Hoc Indexes ability where the Query planner will create an in memory
> index based on the Select, Update, Insert or Delete commands.

How is that supposed to work?  In order to create an index you would need to 
visit all the rows in the table.  If you do that, you could just as well 
answer the query off a sequential scan.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/