Re: [GENERAL] strange behaviour in plpgsql:null arguments

2005-11-29 Thread Michael Fuhr
On Mon, Nov 28, 2005 at 03:39:37PM +0200, Peter Filipov wrote: > I can't detect whether i passed a NULL to stored procedure > in plpgsql when it happens that I use composites This came up a few months ago; see Tom Lane's response to the following message: http://archives.postgresql.org/pgsql-sql/

[GENERAL] strange behaviour in plpgsql:null arguments

2005-11-28 Thread Peter Filipov
Hi, I think I found something that is strange. I can't detect whether i passed a NULL to stored procedure in plpgsql when it happens that I use composites I warn that I haven't read the sql standards though. Here is the code: CREATE TYPE ttype AS ( t1 int, t2 int ); CREATE OR REP