| From: | Michael Blakeley <mike(at)blakeley(dot)com> |
|---|---|
| To: | Bruce Guenter <bruceg(at)em(dot)ca> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Stripping a prefix |
| Date: | 2000-08-26 18:25:42 |
| Message-ID: | p05000e0bb5cdbbe708df@blakeley.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Date: Fri, 25 Aug 2000 09:35:43 -0600
> From: Bruce Guenter <bruceg(at)em(dot)ca>
> To: pgsql-general(at)postgresql(dot)org
> Subject: Stripping a prefix
>
> Is there a function available to strip a string from the start of a
> string? trim and ltrim can strip any occurrence of a set of characters
> from the start of a string, but I want to be able to strip an exact
> string. In particular, if the string starts with "www." (including the
> dot), then it should be stripped.
trim(leading 'www.' from foo)
-- Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Barnes | 2000-08-26 18:49:25 | RE: pgaccess not connecting |
| Previous Message | Aleksandar Lazic | 2000-08-26 18:09:13 | Scalability from Postgresql |