CODEWITHSUNDEEP
postgresqlplpgsql
ragnvald
ragnvald

Reputation: 123

Returning result from two functions within a function - how?

I have two functions, qdgc_getlonlat and qdgc_getrecursivestring, which separately return a string. I am now creating a new function where the goal is concatenate the results from the said functions. This is where I am now:

return query 
  select * 
  from qdgc_getlonlat(lon_value,lat_value) 
  union distinct 
  select * 
  from qdgc_getrecursivestring(lon_value,lat_value,depthlevel,'');

Unfortunately it returns an array which look slike this:

enter image description here

Not too bad, but I would like the functions to be returned as a concatenated text string like this:

E007S05BDCA

How can I do this?

Upvotes: 0

Views: 92

Answers (1)

S-Man
S-Man

Reputation: 23676

Why not simply concatenate them?

SELECT
    qdgc_getlonlat(lon_value,lat_value)  || qdgc_getrecursivestring(lon_value,lat_value,depthlevel,'')
FROM
    mytable

Upvotes: 2

Related Questions