Re: String Search - Mailing list pgsql-sql

From David Johnston
Subject Re: String Search
Date
Msg-id 022001cda26a$7c13d500$743b7f00$@yahoo.com
Whole thread Raw
In response to String Search  (Fabio Ebner - Dna Solution <fabio.ebner@dnasolution.com.br>)
List pgsql-sql
> -----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.





pgsql-sql by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Calling the CTE for multiple inputs
Next
From: Craig Ringer
Date:
Subject: Re: Calling the CTE for multiple inputs