Skip site navigation (1) Skip section navigation (2)

Multi-line text fields

From: Mike Toews <mwtoews(at)sfu(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Multi-line text fields
Date: 2008-09-22 21:56:36
Message-ID: 48D81494.9030308@sfu.ca (view raw or flat)
Thread:
Lists: pgsql-sql
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't appear to do this)

Thanks in advance.
-Mike


Responses

pgsql-sql by date

Next:From: Nicolas BeuzebocDate: 2008-09-22 22:49:38
Subject: Special grouping on sorted data.
Previous:From: Mark RobertsDate: 2008-09-22 16:39:08
Subject: Re: exclusion query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group