Thread: String Search
Anyone know the best way to do one select in String field? tks
> -----Original Message----- > From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql- > owner@postgresql.org] On Behalf Of Fabio Ebner - Dna Solution > Sent: Thursday, October 04, 2012 3:41 PM > To: pgsql-sql@postgresql.org > Subject: [SQL] String Search > > Anyone know the best way to do one select in String field? > > tks You are going to need to phrase a better question. In the meantime please read the documentation on the various built-in string functions available. I've provided links to the function index page (look for "string functions") as well as PostgreSQL's full text search capability since both are "string" related. http://www.postgresql.org/docs/9.2/interactive/functions.html http://www.postgresql.org/docs/9.2/interactive/textsearch.html My best guess is you want to learn about substring functions and/or regular expressions. David J.