Re: [HACKERS] PL/pgSQL a great procedural language for PostgreSQL
Hannu Krosing <hannu@trust.ee>
From: Hannu Krosing <hannu@trust.ee>
To: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Cc: Jan Wieck <jwieck@debis.com>, Tom Lane <tgl@sss.pgh.pa.us>, jose@sferacarta.com, pgsql-hackers@postgreSQL.org
Date: 1998-11-06T09:20:23Z
Lists: pgsql-hackers
Thomas G. Lockhart wrote: > > > For arguments passed by value it > > is totally impossible to know if it's a NULL by looking at > > the value itself. > > Is this a sufficient reason to move toward having all user-oriented data > types be pass-by-reference? If we don't do that, then we would need to > pass a null flag for every parameter, or an array of flags, or have some > global array which contains the null flags (which we might get away with > since Postgres is pretty much single threaded and non-reentrant in the > backend code). What other options might there be? Perhaps make the isNull flag a bitmap ? In case it is an int (I haven't looked), we get room for flagging 32 arguments Also I hope that most current code will run unchanged, in case it tests for 0 / not 0 ---------------- Hannu