Expected behaviour of \d in regexp with exponent numbers ?

From: Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Expected behaviour of \d in regexp with exponent numbers ?
Date: 2014-09-01 13:14:24
Message-ID: 54047130.3000908@codata.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I just came accross this trying to upgrade my server from 8.4.8 to 9.3.4 :

SELECT substring('²' FROM E'\\d');

8.4 : NULL
9.3 : "²"

Am I correct to expect NULL in this case ?
Thanks !

--
Arnaud

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2014-09-01 13:42:39 Re: Expected behaviour of \d in regexp with exponent numbers ?
Previous Message Guillaume Lelarge 2014-09-01 05:48:49 Re: Performance issue with postgres_fdw