Recuperate each line of a result into a variable ?
Hello,
I would like to know how to recuperate the results of a request.
I read the O'Reilly book about Postgresql and and know there are 2 ways
in PL/pgSQL to do that :
1.
declare
variable type;
select into variable column for table where...
2.
declare
variable table%ROWTYPE
for variable in select * from table where...
What I want to do is to make a multitable request and to recuperate
each line of the result by stocking a number or text into variable
eg with int;
declare
sum int := 0;
for variable in select count(distinct sold), name from books natural
join authors... loop
sum = sum + sum; ...
eg with text
declare
list text := '''':
variable as text;
for variable in select title from books natural join authors... loop
if
variable like ''The%''
list := list || variable.title || ''\n'' ...
Thanks.
C. Tobini
if i understand your problem right, you could use a View type as return type
... in this view you declare the fields you want to return ...
thanks,
vish
Show quoted text
On 7 Nov 2005 03:15:21 -0800, ctobini <ctemp2@free.fr> wrote:
Hello,
I would like to know how to recuperate the results of a request.
I read the O'Reilly book about Postgresql and and know there are 2 ways
in PL/pgSQL to do that :1.
declare
variable type;
select into variable column for table where...2.
declare
variable table%ROWTYPE
for variable in select * from table where...What I want to do is to make a multitable request and to recuperate
each line of the result by stocking a number or text into variableeg with int;
declare
sum int := 0;
for variable in select count(distinct sold), name from books natural
join authors... loop
sum = sum + sum; ...eg with text
declare
list text := '''':
variable as text;
for variable in select title from books natural join authors... loop
if
variable like ''The%''
list := list || variable.title || ''\n'' ...Thanks.
C. Tobini
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?