"Gauthier, Dave" <dave.gauthier@xxxxxxxxx> writes: > bi_hsx_a0_latest=# select regexp_replace('xxx','^xxxy$',null); > regexp_replace > ---------------- > > (1 row) > But why did it return null in this case? regexp_replace is strict, so it never even gets called when there's a null input. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general