Re: Found a bug in the procedural languages code relating to LIMIT 1 - Mailing list pgsql-general

From Tod McQuillin
Subject Re: Found a bug in the procedural languages code relating to LIMIT 1
Date
Msg-id Pine.GSO.4.31.0101110933210.578-100000@sysadmin
Whole thread Raw
In response to Found a bug in the procedural languages code relating to LIMIT 1  (<drevil@sidereal.kz>)
List pgsql-general
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


pgsql-general by date:

Previous
From:
Date:
Subject: Found a bug in the procedural languages code relating to LIMIT 1
Next
From: Tom Lane
Date:
Subject: Re: Found a bug in the procedural languages code relating to LIMIT 1