I have a case I need to replace multiple substrings within 1 column using PostgreSQL. Example: Region City Moscow obl Istra Rep Bashkortostan Ufa Udmurtskaya Rep Izhevsk I need all substrings 'obl' to be replaced with 'oblast' and 'Rep' replaced…
I have a Postgres database. It has two tables that we're concerned with right now. Users has a Name field and an ID field, and Events has a UserID field (FK to Users.ID), EventType field (typed as integer), and Time…
I use PostgreSQL 13.15 version and i don't understand how to make column case insensitive. This is table languages and column code is primary key. I want to make it case insensitive. CREATE TABLE IF NOT EXISTS public.languages ( code…
I want to understand why mySQL says there's an error in the syntax when I try to run this query: select g1.*, g2.* from (select * from Customer where referee_id is not null) Logs g1, Logs g2 Am I not…
I have a question. I have the following scheme CREATE TABLE 'redirect3' ( id INT, short_url_id INT, browser SYMBOL capacity 256 CACHE, platform SYMBOL capacity 256 CACHE, os SYMBOL capacity 256 CACHE, referrer_domain VARCHAR, country SYMBOL capacity 256 CACHE, language…
I have a table like this : No Name Product Type Num of Units 1 ADA B112 3 Pcs 2 ADA B253 1 Pcs 3 ADA K23 6 Pcs 4 DUZK l1 10 Pcs 5 DUZK l5 10 Pcs 6…
I have a row in the following table which is the first row but added to the table at the end and now I'd like to modify the table in a way to show employee ids in order starting by…
I have a view and its taking longer time to execute so i need to write simple query to rather than view. CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_party_make_subcat_size_map` AS select distinct `m`.`part_name` AS `material_name`,`pt`.`pk_id` AS `pk_id`, `pms`.`fk_party_id` AS…
Resolved: I was misunderstanding how indexing works. The issue was that I only had single-column indexes and so by joining another table or adding a WHERE clause, SQL could no longer do a simple run through the index, but needed…
uid created_date user_id 1 2023-07-05 05:50:00.000 1 2 2023-07-05 06:50:00.000 1 3 2023-07-05 06:50:00.000 1 4 2023-07-05 06:40:46.000 2 5 2023-07-05 06:57:46.000 2 6 2023-07-05 06:43:46.000 2 For example, above is the data. I am looking for output to have…