Re: [SQL] SRF Functions don't want to return empty tuple

2003-09-29 Thread Stephan Szabo
On Mon, 29 Sep 2003, GRIMOIS Eric wrote: > > On Mon, 29 Sep 2003, GRIMOIS Eric wrote: > > > > > 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 var

Re: [SQL] SRF Functions don't want to return empty tuple

2003-09-29 Thread Stephan Szabo
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, >

Re: [SQL] SRF Functions don't want to return empty tuple

2003-09-29 Thread Richard Huxton
On Monday 29 September 2003 17:18, 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) N

Re: [SQL] SRF Functions don't want to return empty tuple

2003-09-29 Thread GRIMOIS Eric
- 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 > >

[SQL] SRF Functions don't want to return empty tuple

2003-09-29 Thread GRIMOIS Eric
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), CONSTR