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…
For my database I want natural ('A2'<'A12'), case-insensitive sorting, so for testing I created a new collation with CREATE COLLATION tomscollation (provider = icu, locale = 'de-u-kn-true-ks-level2'); My end goal is to use such a collation as the default collation…
I'm oversimplifying my problem a bit. I have a table with the following format: id parent_id name 1 [null] id1 2 1 id2 3 2 aa3 4 3 bb4 5 2 abc 6 [null] abc1 I want to retrieve, in…
Supposing I have something like Name username Mike BestMike99 Someone DaBest What query do I need to run in order to SELECT/return a json like json_agg {Mike: BestMike99, Someone: Dabest}
We currently have a PostgreSQL 11 Server which is about to be upgraded to version 15. There is a test box running Fedora 37. I'd like to try out several scripts on top of these different versions and for that…
I am beginner php developer. I need use in my project function similarity from pgsql. I have table: CREATE TABLE IF NOT EXISTS table_name (id serial primary key, prg_id TEXT, code TEXT, city TEXT, area TEXT, street TEXT, numer TEXT,,…
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…
Suppose the following, create table person (id serial primary key); create table person_rating ( id serial primary key, person_id bigint references person, rating smallint constraint rating_person_rating_check check (rating > 0 and rating <= 5) ); insert into person values (1);…
I have 3 tables in a database A, B and C which share the same column "name". B has an attribute "title" and C has an attribute "age". I am looking to write a SQL query where I will have…
I am new to Postgres and would like to learn how to split multiple email address at once and the final table ouput would have 3 columns username, domain, extension. For example I have multiple email address. [email protected] and so…