Re: CREATE INDEX...USING

2022-08-31 Thread Bruce Momjian
On Thu, Aug 18, 2022 at 12:32:28PM -0400, Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 11:21:58PM -0400, Bruce Momjian wrote: > > However, CREATE INDEX just lists the parameters, not the keywords, so it > > was already there as 'method', as you mentioned above. I will just > > remove the USING s

Re: CREATE INDEX...USING

2022-08-18 Thread Bruce Momjian
On Wed, Aug 17, 2022 at 11:21:58PM -0400, Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 05:11:23PM -0400, Jeff Janes wrote: > > That looks good to me.  But now looking over the linked pages more, it seems > > like https://www.postgresql.org/docs/current/indexes-types.html was never > > changed to

Re: CREATE INDEX...USING

2022-08-17 Thread Bruce Momjian
On Wed, Aug 17, 2022 at 05:11:23PM -0400, Jeff Janes wrote: > That looks good to me.  But now looking over the linked pages more, it seems > like https://www.postgresql.org/docs/current/indexes-types.html was never > changed to admit the possibility of custom index access methods (like bloom) Uh,

Re: CREATE INDEX...USING

2022-08-17 Thread Jeff Janes
On Wed, Aug 17, 2022 at 2:58 PM Bruce Momjian wrote: > On Wed, Aug 17, 2022 at 12:41:03PM -0400, Jeff Janes wrote: > > This was recently added to CREATE INDEX reference page: > > > > +The optional USING clause specifies an index > > +type as described in . If not > > +spe

Re: CREATE INDEX...USING

2022-08-17 Thread Bruce Momjian
On Wed, Aug 17, 2022 at 12:41:03PM -0400, Jeff Janes wrote: > This was recently added to CREATE INDEX reference page: > > +        The optional USING clause specifies an index > +        type as described in .  If not > +        specified, a default index type will be used based on the > +        

CREATE INDEX...USING

2022-08-17 Thread Jeff Janes
This was recently added to CREATE INDEX reference page: +The optional USING clause specifies an index +type as described in . If not +specified, a default index type will be used based on the +data types of the columns. But I think this is wrong, the default type

Re: CREATE INDEX USING documentation

2022-08-12 Thread Bruce Momjian
On Sat, Jul 23, 2022 at 12:46:31PM -0400, Bruce Momjian wrote: > On Sat, Jan 15, 2022 at 11:01:58PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/14/sql-createindex.html > > Description: > >

Re: CREATE INDEX USING documentation

2022-07-23 Thread Bruce Momjian
On Sat, Jan 15, 2022 at 11:01:58PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/sql-createindex.html > Description: > > In the CREATE INDEX > synopsis(https://www.postgresql.org/docs/current/s

CREATE INDEX USING documentation

2022-01-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createindex.html Description: In the CREATE INDEX synopsis(https://www.postgresql.org/docs/current/sql-createindex.html), the USING method parameter is listed, however in the PARAMETER