Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 25 Jan 2008 10:29:30 -0600
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.
- References:
- regex_replace problem
- From: Gary Stainburn
- Re: regex_replace problem -additional
- From: Gary Stainburn
- regex_replace problem
- Prev by Date: Re: This SQL works under Mysql, not Postgresql.
- Next by Date: Re: This SQL works under Mysql, not Postgresql.
- Previous by thread: Re: regex_replace problem -additional
- Next by thread: Re: regex_replace problem
- Indexes: