CREATE OR REPLACE FUNCTION display_columns_data(table_name varchar, columns_to_display varchar[]) RETURNS TABLE (result_row json) AS $$ BEGIN RETURN QUERY EXECUTE 'SELECT ' || array_to_string(columns_to_display, ',') || ' FROM ' || table_name; END; $$ LANGUAGE plpgsql; SELECT * FROM display_columns_data('employees', ARRAY['first_name', 'last_name']); Detail:…
I have a table in Postgres 14.9: Name (Txt) Detail (JSONB) state (JSONB) apple [{ "code": "156", "color": "red" }, { "code": "156", "color": "blue" }] [{ "ap": "good", "op2": "bad" }] orange [{ "code": "156", "color": "red" }, {…
I'm trying to generate the Fibonacci sequence with a function in SQL. It takes an input parameter pstop integer (10 by default) and returns a table with all Fibonacci numbers less than pstop. But the output starts with these numbers…
Using PostgreSQL 9.6, I'm trying to insert rows into a table map, generated from another table tbl. tbl name in1 in2 a 1 b 2 {3} c 4 {5,6} d 7 {8,9,10} Should result in this: map name out1 out2…