Thread: Undocumented feature in CREATE INDEX...

While perusing the CreateIndex source and the parse table, I noticed
that CREATE INDEX supports a WITH clause.  The only value that can be
specified in the WITH clause is "islossy".

So the following statement will parse correctly and will actually set
the 'isloosy' flag on in the index.
   CREATE INDEX foo_bar_index ON foo (bar) WITH (islossy) ;

This isn't documented in the User's manual .  It probably isn't real
important, I just thought I would mention it.

Jeff

Hi, all:

I'm trying the example in:
http://www.postgresql.org/docs/postgres/c43624375.htm
and then when I create the table I got the error:

ERROR:  parser: parse error at or near "desc" 

then I change the field 'desc' to 'descirbe' and every thing ok. I'v check the link:
http://www.postgresql.org/docs/postgres/syntax.htm#AEN426
find out that the world 'desc' have been a reserved world, so I think may be the 
example above a little bit old. May be need to fix.

Laser