Horton

Re: Oracle-compatible lpad/rpad behavior

Jonathan Ellis <jellis@advocast.com>

View thread View on postgr.es
From: "Jonathan Ellis" <jellis@advocast.com>
To: <pgsql-general@postgresql.org>
Date: 2000-12-08T15:46:19Z
Lists: pgsql-hackers, pgsql-general 
> 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