| From: | "David Johnston" <polobo(at)yahoo(dot)com> |
|---|---|
| To: | "'Fabio Ebner - Dna Solution'" <fabio(dot)ebner(at)dnasolution(dot)com(dot)br>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: String Search |
| Date: | 2012-10-04 19:57:28 |
| Message-ID: | 022001cda26a$7c13d500$743b7f00$@yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> -----Original Message-----
> From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-
> owner(at)postgresql(dot)org] On Behalf Of Fabio Ebner - Dna Solution
> Sent: Thursday, October 04, 2012 3:41 PM
> To: pgsql-sql(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-10-05 03:34:33 | Re: Calling the CTE for multiple inputs |
| Previous Message | David Johnston | 2012-10-04 19:51:24 | Re: Calling the CTE for multiple inputs |