Re: Stripping a prefix - Mailing list pgsql-general

From Michael Blakeley
Subject Re: Stripping a prefix
Date
Msg-id p05000e0bb5cdbbe708df@blakeley.com
Whole thread Raw
In response to Stripping a prefix  (Bruce Guenter <bruceg@em.ca>)
List pgsql-general
>  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

pgsql-general by date:

Previous
From: Jesus Aneiros
Date:
Subject: Re: pgaccess not connecting
Next
From: Bill Barnes
Date:
Subject: RE: pgaccess not connecting