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…
I am new to Postgresql (v.13). I have 50 tables into a "ign" schema (schema other than public). I would like for each of these 50 tables: Add a prefix to the name of the table: "IGN_bdTopo_" Add a suffix…
So, let me start with saying that I'm a complete Noob when it comes to SQL. Ive Got two tables within a Schema: Attributes and Skills. I wanted to automatically add the Skills for Each Attribute, since I already got…
I have a question, what is missing or wrong in the RETURN statement that it keeps crashing error 2F005 I am creating a table to log errors drop table if exists public.funkcja_x; create table public.funkcja_x ( error_alert text ); I…
I have a DB function, say "myWrapperFunction"(), which returns a JSON array of objects as below: select * from "myWrapperFunction"() >> [{"a":"b","c":"d"},{"e":"f"}] I have a table "table1" with column 'column1'. I need to pass the values from table1.column1 into myFunction()…
i'm creating a trigger that triggers on INSERT on a table, and i wish to log the structure of tables inserted so i wrote this Function CREATE OR REPLACE FUNCTION update_table_log_received() RETURNS TRIGGER AS $$ DECLARE added_column TEXT; target_table_name TEXT;…
I need to monitor the ongoing flow of data using the latest created date for a set of tables. Basically, I need to batch run SELECT MAX(z_date_creation) FROM table_schema.table_name on a set of tables I retrieve with SELECT c.table_schema, c.table_name…
The function doesn't throw any error nor does it show any return value. CREATE OR REPLACE FUNCTION login(iemail VARCHAR,ipassword VARCHAR) RETURNS TABLE(id INTEGER, name VARCHAR, lastName VARCHAR, age INTEGER, mobile VARCHAR,email VARCHAR) LANGUAGE 'plpgsql' AS $$ #variable_conflict use_variable BEGIN RETURN…
Here's the problem. create table customer ( customer_id int generated by default as identity (start with 100) primary key ); create table cart ( cart_id int generated by default as identity (start with 100) primary key ); I want to…
I want to count certain values in all tables of a schema that contain a column that can contain those values. Was hoping to use a LATERAL join to loop over all tables, but I'm running into issues: select fully_qualified_table_name,…