> Michal Szymanski writes:
> > CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
> > test VARCHAR)
> > AS $$
> > BEGIN
> > -- @todo hide password
> > RETURN QUERY
> > SELECT id ,test
> > FROM bug_table
> > ;
> > END;
> > $$
> > LANGUAGE plpgs
. lv_id = rs.column(1) *if not a zero based
language*.
> Date: Fri, 3 Jul 2009 17:49:42 +0200
> Subject: Re: [GENERAL] How to use RETURN TABLE in Postgres 8.4
> From: pavel.steh...@gmail.com
> To: t...@sss.pgh.pa.us
> CC: dy...@poczta.onet.pl; pgsql-general@postgresql.org
>
&
2009/7/3 Tom Lane :
> Michal Szymanski writes:
>> CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
>> test VARCHAR)
>> AS $$
>> BEGIN
>> -- @todo hide password
>> RETURN QUERY
>> SELECT id ,test
>> FROM bug_table
>> ;
>> END;
>> $$
>> LANGUA
Michal Szymanski writes:
> CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TABLE (id INT8,
> test VARCHAR)
> AS $$
> BEGIN
> -- @todo hide password
> RETURN QUERY
> SELECT id ,test
> FROM bug_table
> ;
> END;
> $$
> LANGUAGE plpgsql STRICT SECURITY DEFINER
I'written something like this:
CREATE TABLE "bug_table" (
"id" BIGINT NOT NULL,
test VARCHAR,
CONSTRAINT "test_table_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;
INSERT INTO bug_table (id,test) VALUES (1,'test');
select * from bug_table;
CREATE OR REPLACE FUNCTION buggy_procedure() RETURNS TAB
