On Wed, Jan 12, 2005 at 11:08:55PM +0000, Fahad wrote: > PostgreSQL version: 8.0.0rc2
8.0.0rc5 is the latest -- it would be best to test with that to get the most recent bug fixes. > In an empty table, if I do this: > > "SELECT some_field WHERE some_field = 45 ORDER BY time"; ERROR: column "some_field" does not exist This isn't a valid query. > This returns instantly with no results. However, doing the following takes > forever to return: > > "SELECT some_field WHERE some_field = 45 ORDER BY time LIMIT 1"; This isn't a valid query either. Please post an actual test case -- the exact series of steps we can take to reproduce the problem. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
