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
