On Fri, Jun 02, 2006 at 02:47:22AM -0700, badlydrawnbhoy wrote: > I need to locate all the entries in a table that match , but only after > a number of characters have been ignored. I have a table of email > addresses, and someone else has erroneously entered some addresses > prefixed with 'mailto:', which I'd like to ignore.
Look here: http://www.postgresql.org/docs/7.4/interactive/functions-string.html especially the substring function will help you. Joachim PS: You should also consider upgrading to 7.4.13 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq