Hi, I think I have managed to get a line ending character in some of my text
fields. If I do a select I get this:
array_design_id | gene_identifier | control_name
-----------------+---------------------------+-------------------
10 | SC-Calibration_10 (13F24) | SC-Calibration_10
10 | SC-Calibration_10 (13E24) | SC-Calibration_10
8 | SC-Calibration_10 (9H17)
| SC-Calibration_10
8 | SC-Calibration_10 (9G17)
| SC-Calibration_10
So I think in some cases the gene_identifier has a line ending character, I
am trying to select on it, but cannot seem to find the right syntax:
select * from array_scheme where gene_identifier like '%\\r';
And have tried various combinations of \\r\\f, \\f\\r, \\f, \\n etc....
Anybody have any ideas of what I may be doing wrong... Or what maybe going
on here?
Thanks for any help
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
