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

Tag: composite-types

PostgreSQL parses string literal as record before calling cast

By adminPosted on January 16, 2023

Question : In my PostgreSQL 9.6 database, I have a composite type, let’s call that type widget. I have a […]

What type of rows does `SELECT my_table FROM my_table` return?

By adminPosted on January 12, 2023

Question : I sometimes encounter this SELECT statement (in JSON-related answers on stackexchanges): SELECT my_table FROM my_table; It seems to […]

Is ‘internallength’ always useful in custom type definition in Postgres?

By adminPosted on October 31, 2022

Question : In our database we use a custom type to store 3D locations: CREATE TYPE float3d AS ( x […]

AutoIncrement non-primary key or Make unique composite key?

By adminPosted on October 3, 2022

Question : I have a db with a table that has a rollover value such as OrderNumber and another column […]

PostgresSQL: Get single attribute of UDT in SELECT statement

By adminPosted on September 7, 2022

Question : I created a user-defined type in a PostgreSQL 9.2 database and am trying in the SELECT statement to […]

Return type of JOINing stored procedure – PostgreSQL

By adminPosted on September 7, 2022

Question : Is it possible to express return type of stored procedure that returns joined tables using table type of […]

Good layout of 3d point data for spatial queries in Postgres?

By adminPosted on August 24, 2022

Question : Like shown in another question, I deal with a lot (>10,000,000) entries of points in a 3D space. […]

why is mysql not using the composite index on my query?

By adminPosted on August 7, 2022

Question : Here is my query. select user_id, sum(user_points.points) overallpts, username from user inner join user_points on user.user_id = user_points.user_id […]

PostgreSQL – Return type and EXECUTE QUERY

By adminPosted on May 1, 2022

Question : My function returns a setof composite type, however the RETURN EXECUTE seems to return some other unknown type: […]

How to set/get a field of a nested composite type variable?

By adminPosted on April 3, 2022

Question : For example: create type t1 as (a int2, b text, c boolean); create type t2 as (a t1, […]

  • 1
  • 2
  • 3

Recent Posts

  • Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring
  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication

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