On Tue, Oct 20, 2015 at 11:09 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Probably it was my request. I don't like to using NULL as value, that should > be ignored. The "hint" is clean, there NULL can be ignored, but what about > DETAIL or MESSAGE?
If the field is required - as MESSAGE is - then its absence is an error. If the field is optional, treat a NULL if the parameter were not supplied. > I am strong in my opinion about PLpgSQL RAISE statement behave, but on > second hand, proposed function should not be 100% same as RAISE stmt. More > we can simply add a parameter like "ignore_nulls" I would be willing to bet you a drink that 99.9% of people will want the behavior Jim is advocating, so I don't think this should be configurable. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers