Re: [BUGS] Problem using LIMIT 1 when only 1 record exists.

2003-11-28 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > "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. Whe

Re: [BUGS] Problem using LIMIT 1 when only 1 record exists.

2003-11-28 Thread Neil Conway
"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