Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: array

Using postgres to select a filtered array

By adminPosted on February 1, 2023

Question : I’m looking to select data from a table that contains an ID, and an array of values. But […]

Postgresql: How to pass an array to trigger function in TG_ARGV?

By adminPosted on January 28, 2023

Question : I’ve got some fairly generic Postgres trigger functions that I’d like to re-use across a few different tables. […]

PostgreSQL, finding elements by value in numeric JSON arrays

By adminPosted on January 19, 2023

Question : I have a table defined as: create table dummy (jdata jsonb); I inserted the following two rows: insert […]

Why is intarray’s push `+` so much faster than array-to-element concatenation `||`?

By adminPosted on January 14, 2023

Question : When it comes to using arrays of ints, I always default to using intarray. But, now I’m wondering […]

Modify all array entries in all records of a table at once

By adminPosted on January 9, 2023

Question : I have a schema that involves an array of timestamps. Due to an import problem all the timestamps […]

How do I speed up a string manipulation query where I want to replace characters, extract certain values and update a table with the results?

By adminPosted on January 7, 2023

Question : I am trying to extract information from strings that are presented in a key-value format, with the keys […]

how to search this field in Postgres for an array of characters

By adminPosted on January 6, 2023

Question : I have a users table which is an id, name, and tags. I’d like to search tags for […]

Join on unnested integer array column and count occurrences in array

By adminPosted on January 2, 2023

Question : I am trying to join two tables after I have unnested one of them. The tables are: CREATE […]

Postgresql: Pattern match against array elements?

By adminPosted on January 2, 2023

Question : Is there any way to do a pattern match against the elements of an array in postgresql (9.4 […]

How do You concatenate a value to an array that was retrieved through a query in sql?

By adminPosted on December 31, 2022

Question : I have a table named “mkvtable” that establishes a correspondence between individual strings and arrays of strings: word […]

  • 1
  • 2
  • 3
  • …
  • 17

Recent Posts

  • Using postgres to select a filtered array
  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding