> > Why does this not work? Am I doing something wrong?
> > raise notice '' varop is '',varop;
> raise notice '' varop is %'', varop;
Arrrg! How did I miss that one.. I've been writing notice lines for
Ok, well I seem to have found the "real" problem this time ;)
CREATE FUNCTION update_sentitems(text,int4) RETURNS bool AS '
varop alias for $1;
raise notice '' varop = %'',varop;
' LANGUAGE 'plpgsql';
NOTICE: varop = INSERT
as expected, however if you give
this is returned:
NOTICE: varop = <NULL>
BTW, it doesn't matter if both parameters are text or int4. Also, it
doesn't matter which one is given as null, they both turn up null.
Bottom line seems to be that if you call the function with any parameter
null, they are all null. Sooo.. what's up here? Is this a bug that's
been fixed in 7.0.3? (I'm still using 7.0.2).
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 2001-02-19 23:24:25|
|Subject: Unportable code in odbc's dlg_specific.h|
|Previous:||From: Adam Haberlach||Date: 2001-02-19 20:07:31|
|Subject: First-time JDBC setup with Jakarta! Whee!|