On Sat, 11 Oct 2003, Bill Shui wrote: > Hi, > > I am using postgreSQL 7.3.4 > > I have a single table in the databasse. > > mytable(id, tag, parent, label) > all in int8. > > hash index is built for id and btree index for all attributes. >
Hash indexes are generally a bad idea in 7.3. > select tag from mytable where id = 1; Try: select tag from mytable where id = 1::int8; This is a known flaw of the typing system which the community has been discussing/attempting to fix for some time. Gavin ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
