"Steve Thames" <steve(at)softlife(dot)com> 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