Question : I would like to distribute for each unique value in col1 an unique value of col2 in an […]
Tag: postgresql-14
PostgreSQL function call error: structure of query does not match function result type
Question : i have function CREATE FUNCTION create_post( txt text, created BIGINT, photourl text, user_id bigint ) RETURNS TABLE( id […]
Which Index Works Better with pg_trgm Extension?
Question : I’m currently building indexing for pattern matching in PostgreSQL database. After reading some articles, I decided to use […]
What does BEGIN ATOMIC … END mean in a PostgreSQL SQL function / procedure?
Question : On PG 14’s documentation, in the CREATE FUNCTION section, the manual says that the body of a LANGUAGE […]