From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Madhavi Daroor <madhavi(at)zoniac(dot)com> |
Cc: | <pgsql-general(at)PostgreSQL(dot)org> |
Subject: | Re: retun cursor |
Date: | 2002-04-08 05:31:03 |
Message-ID: | 20020407222947.C69046-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 8 Apr 2002, Madhavi Daroor wrote:
> When I do fetch 10 from "unnamed cursor 1"
> It says Query Executed Ok. But when am I really going to see the output?
> When Will I see the records? pLease explain the process.....WHat do I fetch
> the cursor into?
Here's a simple function and a fetch passed in through
psql -e
create table test1(a int);
CREATE
insert into test1 values (1);
INSERT 156460 1
insert into test1 values (2);
INSERT 156461 1
insert into test1 values (3);
INSERT 156462 1
insert into test1 values (4);
INSERT 156463 1
insert into test1 values (5);
INSERT 156464 1
create function testfunc1(int4) returns refcursor as '
declare
r refcursor;
begin
open r for select * from test1 where a>=$1;
return r;
end;'
language 'plpgsql';
CREATE
begin;
BEGIN
select testfunc1(2);
testfunc1
--------------------
<unnamed cursor 1>
(1 row)
fetch 1 from "<unnamed cursor 1>";
a
---
2
(1 row)
fetch all from "<unnamed cursor 1>";
a
---
3
4
5
(3 rows)
end;
COMMIT
From | Date | Subject | |
---|---|---|---|
Next Message | impala | 2002-04-08 06:06:54 | Auto Insert date/time |
Previous Message | Vince Vielhaber | 2002-04-08 01:29:23 | Re: Dead devel-corner links |