replace() function problem

From: "Frankie Lam" <frankie(at)ucr(dot)com(dot)hk>
To: pgsql-sql(at)postgresql(dot)org
Subject: replace() function problem
Date: 2003-05-21 12:32:28
Message-ID: bafrjg$2v6t$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I use replace function at psql prompt, but the result turns out to be
weired...
-------------8<--------------------------
twins=# select replace('%a', ' ', ' ');
replace
-----------------------
-0x1.fe98800000001p+0
(1 row)
------------->8--------------------------

Why is that so? Is it a bug?

Thanks...

Frankie Lam

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2003-05-21 13:55:37 Re: Testing castability of text to numeric
Previous Message David W Noon 2003-05-21 11:03:13 Re: Performance on temp table inserts