Stripping a prefix

From: Bruce Guenter <bruceg(at)em(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Stripping a prefix
Date: 2000-08-25 15:35:43
Message-ID: 20000825093543.A25505@em.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings.

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.

Thanks.
--
Bruce Guenter <bruceg(at)em(dot)ca> http://em.ca/~bruceg/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jackson Ching 2000-08-25 16:37:57 Getting the result of a query using COUNT(*)
Previous Message Patrick Goodwill 2000-08-25 13:35:36 JDBC + large objects problem