Ouch,
SS> You've analyzed the situation incorrectly I believe.
SS> In this query in the subselect the id column is an outer reference to
SS> the id column generated from full_sequence.
TL> This is not a bug, it is user error.
TL> The actual problem here is that "id" is a perfectly valid outer re
Frank van Vugt <[EMAIL PROTECTED]> writes:
> Looking forward to your analysis of the following bug:
This is not a bug, it is user error.
> CREATE TYPE full_sequence_type AS (id int);
> CREATE OR REPLACE FUNCTION full_sequence(integer, integer)
> RETURNS SETOF full_sequence_type
> ...
> cr
On Tue, 7 Jun 2005, Frank van Vugt wrote:
> Looking forward to your analysis of the following bug:
You've analyzed the situation incorrectly I believe.
> -- however, the following query will happily run AND return a wrong result
> -- based on the regular table instead of the temporary one
> sel
L.S.
Looking forward to your analysis of the following bug:
database=# select version();
version
PostgreSQL 8.0.3 on i586-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
(1 row)
ST
