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

Tag: functions

How to loop an array and sum values until condition is met?

By adminPosted on March 20, 2023

Question : I have a relational table where I need to loop through and sum amount values until a specified […]

How to pass a table type with an array field to a function in postgresql

By adminPosted on March 20, 2023

Question : i have a table called book CREATE TABLE book ( id smallint NOT NULL DEFAULT 0, bname text, […]

Using LOCATE() Function as SUBSTRING() parameter gives ramdom result. Extracting string from text

By adminPosted on March 16, 2023

Question : I have several rows with a lot of content and i’m trying to find some code and extract […]

Split two delimited strings in same order without function

By adminPosted on March 16, 2023

Question : I am trying to split two columns with delimited strings into rows. The positions of the values in […]

Why would call to scalar function inside a Table Value Function be slower than outside the TVF?

By adminPosted on March 16, 2023

Question : I am writing a Table Value Function, calling the function takes 10x as long as directly running the […]

Postgresql Function Trying to Insert into 1 row instead of 2

By adminPosted on March 14, 2023

Question : Postgresql 9.3, Mac OS X 10.6.7 I created this function and I would like to insert both results […]

Permissions needed for dbms_metadata.get_ddl in a function

By adminPosted on March 13, 2023

Question : Oracle Enterprise 11.2.0.3 I’m receiving: ORA-31603: object “string of type “string” not found in schema “string” when executing […]

How to make PostreSQL functions private (inaccessible to end users)?

By adminPosted on March 13, 2023

Question : When writing a set of PostgreSQL functions with procedural languages, is it possible to make some of the […]

Usage of aggregate function with when self-joining a table

By adminPosted on March 11, 2023

Question : I want to find people from a database who has a weight bigger then the average weight: SELECT […]

Filter rows using a probabilistic filter (bloom filter or cuckoo filter) in Postgres

By adminPosted on March 11, 2023

Question : I have a large table (~1B rows) with a btree index on a single bytea column (~20GB, but […]

  • 1
  • 2
  • 3
  • …
  • 43

Recent Posts

  • Why should I create an ID column when I can use others as key fields? [duplicate]
  • Force NOW to return new timestamps without committing the transaction
  • MariaDB on Windows Server 2012 R2 – out of memory
  • How to easily convert a comma seperated list of ids into a table of rows
  • clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
  • Slow MySQL query
  • Database design : hotel room and its detail
  • How to use GROUP BY in an efficient way without losing attributes? [closed]
  • Query execution time is random, need to identify the root cause
  • Returning data where all categories exactly match
  • Partitioning increases CPU usage in mariadb
  • How to script out push subscription creation at the subscriber?
  • Can a transitive join loop infinitely?
  • 2 similar queries in large sql server table – 1 takes too long
  • Select data from another database instance on the same server in sql server
  • Is it possible to get server roles and database roles in a same query/script?
  • UPDATE performance where no data changes
  • Can I parse a text value from a specific column in a query (MySQL)?
  • MSSQL Geography STIntersects returns 1 when 0 is expected
  • Shrinking log files with SMO

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