Postgres Pro
Downloads
Home   >   mailing lists

replace() function problem - Mailing list pgsql-sql

From Frankie Lam
Subject replace() function problem
Date
Msg-id bafrjg$2v6t$1@news.hub.org
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Testing castability of text to numeric
Next
From: "Eric Anderson Vianet SAO"
Date:
Subject: see toast table