Pattern Matching on Columns - Mailing list pgsql-sql

From Bhuvan A
Subject Pattern Matching on Columns
Date
Msg-id Pine.LNX.4.20.0201171044440.12728-100000@Larry.bks
Whole thread Raw
Responses Re: Pattern Matching on Columns  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Thu Jan 17 10:26:49 IST 2002
----------------------------

Hello,

How can i apply a delimiter, in pattern matching on database columns?

say, in my table i have a column of type 'text' and each of its value
is MULTIPLE lines.

Now, i would like to search for a string in (say delimiter is '\n')
that column and it should result in that many MATCHED LINES instead of
that many matched columns.

How can i achieve this? Thankx in advance.

NOTE: Kindly apologize for any inconvenience.


======================================================================I like work; it fascinates me; I can sit and look
atit for hours.
 
======================================================================

Regards,
Bhuvaneswar.



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Complex view question
Next
From: Markus Bertheau
Date:
Subject: Re: reforming query for 7.0.2