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

Tag: string-representation

Why isn’t to_char IMMUTABLE, and how can I work around it?

By adminPosted on May 11, 2022

Question : How can I index a to_char() of a column? I have tried: adam_db=> CREATE INDEX updates_hourly_idx ON updates […]

Why isn’t to_char IMMUTABLE, and how can I work around it?

By adminPosted on May 2, 2022

Question : How can I index a to_char() of a column? I have tried: adam_db=> CREATE INDEX updates_hourly_idx ON updates […]

Unquoting JSON strings; print JSON strings without quotes

By adminPosted on August 3, 2021

Question : SELECT json_array_elements(‘[“one”, “two”]’::json) gives result | json_array_elements | | :—————— | | “one” | | “two” | I […]

PostgreSQL function’s input/output as JavaScript nested objects [closed]

By adminPosted on June 19, 2021

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

Recent Posts

  • Need to create join on multiple ids on same cell
  • how to find number of empty tables in any schema?
  • Get all records from inner joined tables if second table does not have data
  • Is there an Express version of Azure SQL DB?
  • Optimize schema and query for overlapping date ranges query
  • Merging one-to-many and one-to-one relation in the same JSON object in postgresql
  • Mysql Replication trigger not executing on slave
  • Set priority for an SQL Server role
  • How can I group two joined tables
  • SQL Server Chaining Many-To-Many tables
  • Help with design of sales database
  • Chat schema for PostgreSQL and MongoDB
  • PostgreSQL Database Migration
  • MDX datetime comparison
  • How PostgresSQL stores duplicated VARCHAR values in a column
  • Shrinking T-Log file every weekend basis
  • Dog slow query, needs optimizing, please help
  • Maintaining a production big table
  • get all posts with their associative tags without duplicates
  • build users availability report/Table (using sql)

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