> Date: Fri, 25 Aug 2000 09:35:43 -0600
> From: Bruce Guenter <bruceg@em.ca>
> To: pgsql-general@postgresql.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