Tom Lane wrote:
> "Pavel Stehule" <[EMAIL PROTECTED]> writes:
> > 2008/9/1 Oleg Serov <[EMAIL PROTECTED]>:
> >> ERROR: structure of query does not match function result type
> >> CONTEXT: PL/pgSQL function "buggy_procedure" line 3 at RETURN QUERY*/
>
> > this isn't bug, it's feature.
>
> No, i
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> 2008/9/1 Oleg Serov <[EMAIL PROTECTED]>:
>> ERROR: structure of query does not match function result type
>> CONTEXT: PL/pgSQL function "buggy_procedure" line 3 at RETURN QUERY*/
> this isn't bug, it's feature.
No, it's a bug, and it's not related t
Hello
2008/9/1 Oleg Serov <[EMAIL PROTECTED]>:
> Hello all SQL BUG CODE:
> BEGIN;
> SELECT version(); -- "PostgreSQL 8.3.3 on i686-redhat-linux-gnu, compiled by
> GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14)"
> CREATE TYPE "buggy_enum_first" AS ENUM ( 'bug1', 'bug2', 'bug3' );
>
> CREATE TABLE
Hello all SQL BUG CODE:
BEGIN;
SELECT version(); -- "PostgreSQL 8.3.3 on i686-redhat-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14)"
CREATE TYPE "buggy_enum_first" AS ENUM ( 'bug1', 'bug2', 'bug3' );
CREATE TABLE "bug_table" (
"id" BIGINT NOT NULL,
"buggy_enum_field" "b