On Thu, Nov 05, 2009 at 10:13:28AM -0800, Bob Pawley wrote: > However one variable sometimes returns a null value which invariably > gives a null answer. > > How can I work around this?? What do you want it to do with the NULL value? I'm assuming you want to use COALESCE, something like: COALESCE(n,0) + COALESCE(m,0) -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
