Re: Oracle-compatible lpad/rpad behavior

From: "Jonathan Ellis" <jellis(at)advocast(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle-compatible lpad/rpad behavior
Date: 2000-12-08 15:46:19
Message-ID: 019801c0612e$01d4ff60$0d00a8c0@dsl.inconnect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-08 15:47:37 Re: Indexing for geographic objects?
Previous Message Oleg Bartunov 2000-12-08 15:16:30 Re: Indexing for geographic objects?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-12-08 15:47:37 Re: Indexing for geographic objects?
Previous Message Oleg Bartunov 2000-12-08 15:16:30 Re: Indexing for geographic objects?