regexp_replace( , , , NULL ) returns null?

From: Jim Nasby <jnasby(at)enova(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: regexp_replace( , , , NULL ) returns null?
Date: 2014-05-02 23:34:28
Message-ID: E087E793-BFAF-4C13-9389-B8FA0514DBF5@enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Is there any particular reason for this:

decibel(at)decina(dot)local=# SELECT regexp_replace( 'a', 'a', 'b', null ) IS NULL;
?column?
----------
t
(1 row)

ISTM it’d be a lot better if it treated NULL flags the same as ‘’...
--
Jim Nasby, Lead Data Architect (512) 569-9461

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2014-05-03 01:07:55 Re: Sending out a request for more buildfarm animals?
Previous Message Merlin Moncure 2014-05-02 20:10:19 Re: Supporting multiple column assignment in UPDATE (9.5 project)