Thread: unique indices...

unique indices...

From
Lorenzo Huerta
Date:
Are there any other access methods in postgres 6.3.1 ,other than btree, to
create unique indices on relations with?


Thanks,

     __________________________________________________________________
     *  Lorenzo J. Huerta                                             *
     *  Programming Assistant                                         *
     *  Computing & Networking Networking Architecture and Operations *
     *  New Mexico State University                                   *
     *  phone: (w)(505)646-2582 (h)(505) 521-8699 fax:(505) 646-8139  *
     *  e-mail: lorenzo@nmsu.edu                                      *
     *  Web Site: http://web.nmsu.edu/~ljhuerta                       *
     __________________________________________________________________


Re: [SQL] unique indices...

From
Sferacarta Software
Date:
Hello Lorenzo,

giovedì, 9 luglio 98, you wrote:


LH> Are there any other access methods in postgres 6.3.1 ,other than btree, to
LH> create unique indices on relations with?


LH> Thanks,

LH>      __________________________________________________________________
LH>      *  Lorenzo J. Huerta                                             *
LH>      *  Programming Assistant                                         *
LH>      *  Computing & Networking Networking Architecture and Operations *
LH>      *  New Mexico State University                                   *
LH>      *  phone: (w)(505)646-2582 (h)(505) 521-8699 fax:(505) 646-8139  *
LH>      *  e-mail: lorenzo@nmsu.edu                                      *
LH>      *  Web Site: http://web.nmsu.edu/~ljhuerta                       *
LH>      __________________________________________________________________


1. btree
2. rtree
3. hash

refer to man create_index

Best regards,
 Sferacarta                            mailto:sferac@bo.nettuno.it