On Sat, Nov 30, 2002 at 18:23:56 -0500, Greg Stark <[EMAIL PROTECTED]> wrote: > > It seems like this should be an important optimization given the number of > applications that request max(foo) in a broken attempt to implement sequences. > Occasionally it's not even a broken attempt too.
This has been discussed on the mailing lists many times. You can rewrite the queries using order by and limit clauses if the column is appropiately indexed. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html