Skip site navigation (1) Skip section navigation (2)

Re: Newbie help needed on Functions

From: Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr>
To: 'Jim Steil' <jim(dot)steil(at)customcall(dot)com>,pgsql-novice(at)postgresql(dot)org
Subject: Re: Newbie help needed on Functions
Date: 2002-09-25 08:13:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I'm not an expert, but I think that a function cannot directly return a rows
set. You have to use a cursor

 I use the following (postgresql 7.2) to  get multiple rows in a table, but
the table must exist before you run the function.

Don't forget double quotes (1+1) for the variable in the query

You have to install pl/pgsql language before ...

CREATE FUNCTION test(varchar) RETURNS varchar AS '

declare str alias for $1;

declare str_ok varchar(2);


str_ok = 'OK'

drop table tmp_result;

create table tmp_result as select a.*  from your_table a where

return str_ok;


' LANGUAGE 'pl/pgsql';


Jacques Massé                                                  
Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01 

-----Message d'origine-----
De : Jim Steil [mailto:jim(dot)steil(at)customcall(dot)com]
Envoyé : mardi 24 septembre 2002 19:59
À : pgsql-novice(at)postgresql(dot)org
Objet : [NOVICE] Newbie help needed on Functions

I want to create a function that will return rows from a table based upon a
parameter that I pass.

pgsql-novice by date

Next:From: Maryam BashirDate: 2002-09-25 10:00:47
Subject: problem in gmake and make commands
Previous:From: Nicolas CartronDate: 2002-09-25 07:03:18
Subject: Re: Question about cygwin/Postgre

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group