Postgres Pro
Downloads
Home   >   mailing lists

Re: set return function is returning a single record, multiple times,how can i get all the records in the table( description inside ) - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: set return function is returning a single record, multiple times,how can i get all the records in the table( description inside )
Date
Msg-id 20060428105621.GD8542@webserv.wug-glas.de
Whole thread Raw
In response to set return function is returning a single record, multiple times,how can i get all the records in the table( description inside )  ("Penchalaiah P." <penchalaiahp@infics.com>)
Responses Re: set return function is returning a single record,
List pgsql-sql
Tree view 
am  28.04.2006, um 16:14:10 +0530 mailte Penchalaiah P. folgendes:
> 4) The following is the function that retrieves the records from pss :
> 
> CREATE or replace  FUNCTION ftoc9() RETURNS setof  structrankmaster2
> LANGUAGE 'plpgsql' 
> 
>  AS' DECLARE 
>  rowdata pss%rowtype;
> BEGIN for i in 1..3 loop
> select * into rowdata from pss ;
> return next rowdata ;
> end loop;
> return;
> end';

Your loop is wrong, for i in 1..3 select... and then returns the first
record.


Change this to:

BEGIN .. for rowdata in select * from pss ;   return next rowdata ; end loop; ..
END;

*untestet*




HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===

pgsql-sql by date:

Previous
From: "Penchalaiah P."
Date:
Subject: set return function is returning a single record, multiple times,how can i get all the records in the table( description inside )
Next
From: Alexis Paul Bertolini
Date:
Subject: Re: set return function is returning a single record, multiple