----- Original Message ----- From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "GRIMOIS Eric" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 6:40 PM Subject: Re: [SQL] SRF Functions don't want to return empty tuple
> > 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? > Yes, you're right. Now, it works. Thank you very much The syntax I used was wrong, but is accepted by Postgres. What does it mean ? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
