thanks 2009/12/22 Filip Rembiałkowski <plk.zu...@gmail.com>
> > > 2009/12/22 Pau Marc Munoz Torres <paum...@gmail.com> > > Hi every body >> > > >> >> there is some way to delete or rename an index only if this index exists? >> >> something like >> >> "alter index index rename to pepe if exists" >> >> > for drop - yes: > DROP INDEX IF EXISTS name; > > for rename - there is no simple solution. well, actually there are > solutions but they are more complicated than the problem. > (think of user defined functions) > > > -- > Filip Rembiałkowski > JID,mailto:filip.rembialkow...@gmail.com > http://filip.rembialkowski.net/ > -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193 Bellaterra (Barcelona) telèfon: 93 5812807 Email : paumarc.mu...@bioinf.uab.cat
