How do I add normalize-space into my psql query statement to remove \302\240 from my query results

Asked Apr 01 '21 at 17:35

Active Apr 04 '21 at 07:56

Viewed 22 times

This is my blob statement

(xpath('/d:Invoice/d:InvoiceDetail/d:InvoiceLineItem/d:LineItemDescription/text()',
                             xml,
                             
      '{{d,http://www.m00.com/2019/01/RRRInvoice}}'))[1]::text as Line_ItemDescription,

edited Apr 04 '21 at 07:56

jwvh

50,871
7
38
64

asked Apr 01 '21 at 17:35

user3076464

How do I add normalize-space into my psql query statement to remove \302\240 from my query results

0 Answers0