Re: Found a bug in the procedural languages code relating to LIMIT 1

On 11 Jan 2001 drevil@sidereal.kz wrote:

> Try a function like this:
>
> CREATE FUNCTION foo(...) RETURNS INT4 AS '
> SELECT shoesize FROM customers ORDER BY time LIMIT 1
> ' LANGUAGE 'sql';

What you describe does sound like a bug to me (maybe in the documentation
though).

But this query should be the same and should return only one result:

SELECT shoesize FROM customers WHERE time = min(time)
--
Tod McQuilin