On Mon, 29 Sep 2003, GRIMOIS Eric wrote: > Hi > > I have a problem with SRF functions on a RedHat 8.0 system with PostgreSQL > 7.3.2. > > Schema is following : > > CREATE TABLE public.agents ( > numero_age int4 NOT NULL, > nom_age varchar(30) NOT NULL, > prenom_age varchar(30) NOT NULL, > date_entree_age date NOT NULL, > identite varchar(50), > CONSTRAINT agents_pkey PRIMARY KEY (numero_age) > ) WITH OIDS; > > INSERT INTO public.agents VALUES (78888, 'PERAVIF', 'JO', '1967-06-18', '') > > CREATE FUNCTION public.liste_agents(int4) RETURNS public.agents AS 'SELECT * > FROM agents WHERE numero_age = $1' LANGUAGE 'sql' VOLATILE;
Are you sure you don't want setof public.agents if you want to be able to return an empty set? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
