Home > mailing lists

Multi-line text fields - Mailing list pgsql-sql

From	Mike Toews
Subject	Multi-line text fields
Date	September 22, 2008 21:56:42
Msg-id	48D81494.9030308@sfu.ca Whole thread Raw
Responses	Re: Multi-line text fields (Craig Ringer <craig@postnewspapers.com.au>)
List	pgsql-sql

Tree view

Hi all,

I have some records that have some multiple lines within a single text 
field. (On top of that, I think I have mixed DOS/UNIX line endings too). 
I'm looking for two functions which can operate on a single field:
  1. number of lines  2. a way to select the first line or to trim to the first line only     (the normal trim function
doesn'tappear to do this)
 

Thanks in advance.
-Mike

pgsql-sql by date:

From: Mark Roberts
Date: 22 September 2008, 16:48:58
Subject: Re: exclusion query

From: Nicolas Beuzeboc
Date: 22 September 2008, 22:58:35
Subject: Special grouping on sorted data.

Multi-line text fields - Mailing list pgsql-sql

Previous

Next