"Steve Thames" <[EMAIL PROTECTED]> writes: > The SQL command: > SELECT last FROM table WHERE symbol='Symbol' AND expmoyr='Mmm-YY' ORDER BY > qdate DESC LIMIT 1; > > This query works fine when there is more than one record meeting the > criteria. When there is only 1, the query locks and no result is > returned.
I'm skeptical that LIMIT is broken. Can you provide a reproducible example? Also, what version of PostgreSQL is this? -Neil ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
