Skip site navigation (1) Skip section navigation (2)

Re: Incorrect SQL on CREATE INDEX page

From: "Roderick A(dot) Anderson" <raanders(at)cyber-office(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Subject: Re: Incorrect SQL on CREATE INDEX page
Date: 2010-03-17 15:38:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
Tom Lane wrote:
> Josh Kupershmidt <schmiddy(at)gmail(dot)com> writes:
<snip />
>> Also, a more minor quibble about the same section: the first example says:
>>     To create a B-tree index on the column title  in the table films:
>>     CREATE UNIQUE INDEX title_idx ON films (title);
>> Perhaps the mention of "B-tree" should be omitted here, since "USING
>> btree" is not actually used in the SQL provided. Or is there an
>> explicit guarantee that CREATE UNIQUE INDEX will always use a B-Tree
>> documented somewhere?
> It's pointed out further up the page that btree is the default access
> method.

Maybe change it to  " ... B-tree index (the default) on the column ... " 
for those of us with short memories.


In response to

pgsql-docs by date

Next:From: Magnus HaganderDate: 2010-03-17 18:04:12
Subject: Re: The type of ssl_renegotiation_limit
Previous:From: Tom LaneDate: 2010-03-17 15:13:45
Subject: Re: Incorrect SQL on CREATE INDEX page

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group