Search Results

I want to get users how are not present in a group. The group name is "everybody". I have a join table called groups_users with user_id and group_id. I did this SELECT users.email FROM users WHE …

I'm new to database and I'm lost with transaction. For example in a situation where I have a table sensor_log that receives INSERT constantly and I want to move data to two other tables in one transac …

This is the next version of Sum on distinct and group by But It goes deeper I have this : CREATE TABLE active_connections(id serial PRIMARY KEY, source text NOT NULL, user_id int NOT NULL); INSERT …

I am wondering how could I prevent this to happen and why PostgreSQL is not able to handle it by itself? …

I wanted to count the number queries executed over one day. I have this working version : SELECT DATE_TRUNC('day', starttime) AS date, COUNT(*) AS COUNT FROM stl_query WHERE querytxt LIKE 'CO …

I am using PostgreSQL 10 …

I have this data: CREATE TABLE tickets(user_id int NOT NULL); INSERT INTO tickets VALUES (1); INSERT INTO tickets VALUES (2); INSERT INTO tickets VALUES (3); -- 3 times INSERT INTO tickets VALUES (4); …

I have this : CREATE TABLE tickets(id serial PRIMARY KEY, source text NOT NULL, user_id int NOT NULL, shop_id int NOT NULL, created_at time DEFAULT current_time); INSERT INTO tickets VALUES (0, 'web- …

In a search mode I would like to impact the rank of my search related to age of the document. I have a working version but I found it very complicated. It say "Does the same founded younger document …

I'm testing text search on PostgreSQL and I would like to search for multiple terms based on a custom dictionnary I have : CREATE TABLE events (name text NOT NULL, description text NOT NULL); INSERT …

I am trying to play with PostgreSQL 14 and row level lock on update. …

I have this : CREATE TABLE users ( first_name varchar(60) NOT NULL, last_name varchar(60) NOT NULL ); INSERT INTO users (first_name, last_name) VALUES ('Sylvia ', 'Hoeks'), ('Ha …

I have 3 tables (devices, shops, device_shops_versions). devices can have many device_shops_versions. device_shops_versions table: +----+---------+-----------+---------+---------------------------+ …

I'm adding constraint on an existing table jobs: DROP TABLE IF EXISTS jobs CASCADE; DROP TYPE IF EXISTS job_state; CREATE TYPE job_state AS ENUM ( 'UNSTARTED', 'STARTED', 'FAILED', 'COMPLETED' ); CRE …

The constraint should be written using an OR like (NOT A) OR B ALTER TABLE jobs ADD CONSTRAINT error_message_is_null_if_failed_is_false CHECK ( NOT ( status IN ('UNSTARTED', 'STARTED', 'COMPLETED …