On 11 Jan 2001 drevil(at)sidereal(dot)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