Thread: String Search

String Search

From
Fabio Ebner - Dna Solution
Date:
Anyone know the best way to do one select in String field?

tks





Re: String Search

From
"David Johnston"
Date:
> -----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.