Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
postgres_sql [2019/02/13 07:42]
root [Xml]
postgres_sql [2019/02/13 07:56] (current)
root [Xml]
Line 394: Line 394:
  
 select (xpath('//​ADRNR/​text()',​ name))[1]::​text::​int ​ from sap_name ​ select (xpath('//​ADRNR/​text()',​ name))[1]::​text::​int ​ from sap_name ​
 +</​code>​
 +
 +merging the results of multiple values ​
 +
 +<code sql>
 +SELECT xmlconcat(
 +( select address from sap_address
 +  where  (xpath('//​CLIENT/​text()',​ address))[1]::​text::​int ​ = 1 ) ,   
 +(select name from sap_name ​
 +where (xpath('//​ADRNR/​text()',​ name))[1]::​text::​int ​ = 1) ) as merge    ​
 </​code>​ </​code>​
 == Indexing ==  == Indexing == 
 
postgres_sql.txt · Last modified: 2019/02/13 07:56 by root
 
RSS - 200 © CrosswireDigitialMedia Ltd