On Wed, 09 Jan 2008 00:06:45 -0800 "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> wrote: > Granted there are scenarios where others are FASTER (SELECT > COUNT(*)) but I find that if you are doing those items, you > normally have a weird design anyway. > Sincerely, Sincerely, would you make an example of such a bad design? Or did you just mean that count(*) is bad design in postgresql since there are usually better alternatives in postgresql? I'm not joking. I'd like to learn. -- Ivan Sergio Borgonovo http://www.webthatworks.it ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend