regexp_replace( , , , NULL ) returns null? - Mailing list pgsql-hackers

From Jim Nasby
Subject regexp_replace( , , , NULL ) returns null?
Date
Msg-id E087E793-BFAF-4C13-9389-B8FA0514DBF5@enova.com
Whole thread Raw
Responses Re: regexp_replace( , , , NULL ) returns null?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Is there any particular reason for this:

decibel@decina.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




pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Sending out a request for more buildfarm animals?
Next
From: Josh Berkus
Date:
Subject: New and interesting replication issues with 9.2.8 sync rep