[PostgreSQL] Delete duplicates in array

2022. 6. 22. 17:09ยทDataBase/PostgreSQL

 

 

 

์ค‘๋ณต ์›์†Œ ์‚ฝ์ž…์‹œ ์ œ์•ฝ์กฐ๊ฑด์— ์˜ํ•ด ์‹คํŒจ

 

 

 


๐Ÿ”— Reference

 

9.19. Array Functions and Operators

9.19. Array Functions and Operators Table 9.51 shows the specialized operators available for array types. In addition to those, the usual comparison …

www.postgresql.org

 

Postgres 11 | db<>fiddle

ERROR: new row for relation "address" violates check constraint "check_cities_are_not_duplicate" DETAIL: Failing row contains ({C,C}).

dbfiddle.uk

 

์ €์ž‘์žํ‘œ์‹œ (์ƒˆ์ฐฝ์—ด๋ฆผ)

'DataBase > PostgreSQL' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

[PostgreSQL] Use `identity` instead of `serial`  (0) 2022.06.16
[PostgreSQL] CHECK Constraint  (0) 2022.05.04
[PostgreSQL] Trigger + Transaction  (0) 2022.04.18
[PostgreSQL] Transaction + Pool ์‚ฌ์šฉ์‹œ ์ฃผ์˜  (0) 2022.04.04
[PostgreSQL] Function (feat. trigger)  (0) 2022.03.29
'DataBase/PostgreSQL' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€
  • [PostgreSQL] Use `identity` instead of `serial`
  • [PostgreSQL] CHECK Constraint
  • [PostgreSQL] Trigger + Transaction
  • [PostgreSQL] Transaction + Pool ์‚ฌ์šฉ์‹œ ์ฃผ์˜
M_Falcon
M_Falcon
  • M_Falcon
    Falcon
    M_Falcon
  • ์ „์ฒด
    ์˜ค๋Š˜
    ์–ด์ œ
    • ๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ (432)
      • Web (16)
        • Nodejs (14)
        • Javascript (23)
        • FrontEnd (4)
      • DataBase (39)
        • Fundamental (1)
        • Redis (4)
        • PostgreSQL (10)
        • NoSQL (4)
        • MySQL (9)
        • MSSQL (3)
        • Error (4)
      • Algorithm (79)
        • Algorithm (๋ฌธ์ œํ’€์ด) (56)
        • Algorithm (์ด๋ก ) (23)
      • JVM (65)
        • Spring (13)
        • JPA (5)
        • Kotlin (13)
        • Java (24)
        • Error (7)
      • ๊ธฐํƒ€ (70)
        • Kafka (3)
        • Kubernetes (3)
        • Docker (13)
        • git (19)
        • ์žก๋™์‚ฌ๋‹ˆ (27)
      • ์žฌํ…Œํฌ (11)
        • ์„ธ๋ฌด (4)
        • ํˆฌ์ž (3)
        • ๋ณดํ—˜ (0)
      • BlockChain (2)
        • BitCoin (0)
      • C (32)
        • C (10)
        • C++ (17)
        • Error (3)
      • Low Level (8)
        • OS (3)
        • ์‹œ์Šคํ…œ ๋ณด์•ˆ (5)
      • ๋„คํŠธ์›Œํฌ (3)
      • LINUX (30)
        • Linux (26)
        • Error (4)
      • ์ €์ž‘๊ถŒ๊ณผ ์Šค๋งˆํŠธํฐ์˜ ์ดํ•ด (0)
      • ์ƒ๊ฐ ๋ญ‰์น˜ (6)
      • ๊ถ๊ธˆ์ฆ (2)
      • Private (4)
        • ์ด์ง ๊ฒฝํ—˜ (0)
        • ๊ฟˆ์„ ์ฐพ์•„์„œ (1)
      • Android (21)
        • OS (4)
  • ๋ธ”๋กœ๊ทธ ๋ฉ”๋‰ด

    • ํ™ˆ
    • WEB
    • ์•Œ๊ณ ๋ฆฌ์ฆ˜
    • DataBase
    • Linux
    • Mobile
    • C
    • ๋ฐฉ๋ช…๋ก
  • ๋งํฌ

    • github
  • ๊ณต์ง€์‚ฌํ•ญ

  • ์ธ๊ธฐ ๊ธ€

  • ํƒœ๊ทธ

    database
    java
    javascript
    Git
    linux
    Bitcoin
    ubuntu
    ์•Œ๊ณ ๋ฆฌ์ฆ˜
    kafka
    PostgreSQL
    algorithm
    JPA
    ๋ฐฑ์ค€
    android
    Spring
    Programmers
    Kotlin
    ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค
    docker
    C++
  • hELLOยท Designed By์ •์ƒ์šฐ.v4.10.3
M_Falcon
[PostgreSQL] Delete duplicates in array
์ƒ๋‹จ์œผ๋กœ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”