Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle-compatible lpad/rpad behavior - Mailing list pgsql-general

From Jonathan Ellis
Subject Re: Oracle-compatible lpad/rpad behavior
Date
Msg-id 019801c0612e$01d4ff60$0d00a8c0@dsl.inconnect.com
Whole thread Raw
In response to AW: [HACKERS] Re: is it a bug?  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: ilike and --enable-multibyte=KOI8
Next
From: "Nathan Barnett"
Date:
Subject: Memory Usage