Skip site navigation (1) Skip section navigation (2)

Re: regex_replace problem -additional

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Gary Stainburn" <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: regex_replace problem -additional
Date: 2008-01-25 16:29:30
Message-ID: dcc563d10801250829rb4b0cafx9b9cbfe692069b91@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
On Jan 25, 2008 10:19 AM, Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> wrote:
> Sorry,
>
> should have added that I tried type-casting to see if that fixed it.  It
> didn't.
>
> Gary
>
> goole=# select distinct regex_replace(ud_rfl::text,' *= *'::text,'+'::text)

 \df regexp*
                            List of functions
   Schema   |      Name      | Result data type |  Argument data types
------------+----------------+------------------+------------------------
 pg_catalog | regexp_replace | text             | text, text, text
 pg_catalog | regexp_replace | text             | text, text, text, text

I think you lost a p in there.

In response to

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-01-25 16:32:22
Subject: Re: This SQL works under Mysql, not Postgresql.
Previous:From: Scott MarloweDate: 2008-01-25 16:23:53
Subject: Re: This SQL works under Mysql, not Postgresql.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group