Function not RAISE NOTICE if a parameter is NULL

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Function not RAISE NOTICE if a parameter is NULL
Date: 2010-05-04 22:09:52
Message-ID: w2v18f98e681005041509u784cbfe1vc0cbfa0507aa5866@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a function, that I'm debugging...

If I use NULL in any parameter the function does not RAISE any NOTICE. I
can't pass NULL values in parameters?

[code]
select apr_ins_gder_2_1
('table_fgh' /* Varchar */,
'id_fgh' /* Varchar */,
'5' /* Varchar */,
NULL /* Date */,
'2001-01-05' /* Date */,
'coment...' /* Varchar */)
[/code]

Solutions for pass NULL values in the parameters and receive RAISE NOTICE's?

Sorry for my english.

Best Regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-05-04 22:23:30 Re: Function not RAISE NOTICE if a parameter is NULL
Previous Message Andre Lopes 2010-05-04 22:05:38 Re: How to exit/abort from a function that returns VOID?