R
R
Roman Makarov2015-02-02 23:29:30
PostgreSQL
Roman Makarov, 2015-02-02 23:29:30

How to unwrap multiple results of functions returning setof(postgresql)?

We have the following result set:

rows
("Key1", "Value1")
("Key2", "Value2")
("Key3", "Value3")
("Key4", "Value4")

The question is, is it possible to convert these sets into a table of the form:
keyvalue
Key1Value1
key2value2
Key3Value3
Key3Value3
Key4Value4

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question