Postgres Pro
Downloads
Home   >   mailing lists

Function not RAISE NOTICE if a parameter is NULL - Mailing list pgsql-general

From Andre Lopes
Subject Function not RAISE NOTICE if a parameter is NULL
Date
Msg-id w2v18f98e681005041509u784cbfe1vc0cbfa0507aa5866@mail.gmail.com
Whole thread Raw
Responses Re: Function not RAISE NOTICE if a parameter is NULL
List pgsql-general
Tree view
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,

pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: Re: How to exit/abort from a function that returns VOID?
Next
From: Tom Lane
Date:
Subject: Re: Function not RAISE NOTICE if a parameter is NULL