Re: [GENERAL] Oracle-compatible lpad/rpad behavior

[Jonathan Ellis]

> Returns not empty string but NULL:

The two are equivalent in Oracle.  Try select 'a' || null || 'b' from dual
and compare it to postgres.

-Jonathan