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


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to