Database functions possibly returning more than one row.
When I have a column with separated values, I can use the unnest() function: myTable id | elements ---+------------ 1 |ab,…
sql arrays postgresql window-functions set-returning-functionsSuppose I have a table like this: subject | flag ----------------+------ this is a test | 2 subject is of type text, …
sql postgresql split set-returning-functionsAs far as I can tell, my function properly resembles the samples I've seen. Can someone clue me in as …
postgresql parameter-passing plpgsql set-returning-functionsI'm new to Postgres and have a database with multiple tables of the same structure. I need to select data …
postgresql for-loop plpgsql dynamic-sql set-returning-functionsI'm trying to generate a series in PostgreSQL with the generate_series function. I need a series of months starting …
sql postgresql time-series generate-series set-returning-functionsI was implementing a Query system. I implemented unnest function. Now user was asking about using multiple unnest in a …
sql postgresql unnest set-returning-functionsI am receiving the error: set-valued function called in context that cannot accept a set when executing this function at …
postgresql plpgsql set-returning-functionsGiven a table defined as such: CREATE TABLE test_values(name TEXT, values INTEGER[]); ...and the following values: | name | values | +…
sql arrays postgresql set-returning-functions lateralI am trying to join table and function which returns rows: SELECT p.id, p.name, f.action, f.amount …
sql postgresql join set-returning-functions lateralMy last question Passing an array to stored to postgres was a bit unclear. Now, to clarify my objective: I …
arrays postgresql arraylist plpgsql set-returning-functions