Return-Path: aoki
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA02966; Thu, 29 Jul 93 07:19:36 -0700
Message-Id: <9307291419.AA02966@postgres.Berkeley.EDU>
From: aoki@postgres.berkeley.edu (Paul M. Aoki)
Subject: Re: functions with text type arguments
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Thu, 29 Jul 93 12:26:32 MET DST 
	     <9307291019.AA02008@postgres.Berkeley.EDU> 
Date: Thu, 29 Jul 93 07:25:59 -0700
Sender: aoki@postgres.Berkeley.EDU
X-Mts: smtp

Bart Maessen <Bart.Maessen@fel.tno.nl> writes:
> The returned value of functions which has as an variable
> length argument type is not correct in the case that the variable
> length argument is (null).

the argument is not the NULL pointer.  the argument actually does
not exist -- it's a null value (in the database sense).  hence the
function is not run on the argument at all (since the null value
has no meaning to C functions -- there's no one value you can pass
to ALL possible functions and have them understand that it's null).

when i run this with, say, int4 arguments and int4inc, the same 
thing happens (which is what you would expect) -- the retrieved result 
is null.

i'm looking at the join thingy now.
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki