Pattern Matching on Columns

Поиск
Список
Период
Сортировка
От Bhuvan A
Тема Pattern Matching on Columns
Дата
Msg-id Pine.LNX.4.20.0201171044440.12728-100000@Larry.bks
обсуждение исходный текст
Ответы Re: Pattern Matching on Columns  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: Complex view question
Следующее
От: Markus Bertheau
Дата:
Сообщение: Re: reforming query for 7.0.2