Re: [BUGS] Bug in RETURN QUERY

2008-11-26 Thread raf
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

Re: [BUGS] Bug in RETURN QUERY

2008-09-01 Thread Tom Lane
"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

Re: [BUGS] Bug in RETURN QUERY

2008-09-01 Thread Pavel Stehule
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

[BUGS] Bug in RETURN QUERY

2008-09-01 Thread Oleg Serov
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