Upgrade to Pro — share decks privately, control downloads, hide ads and more …

沖縄観光とPostgreSQL排他制約の話

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for nikawa2161 nikawa2161
December 28, 2025
Technology
0
23

 沖縄観光とPostgreSQL排他制約の話

Avatar for nikawa2161

nikawa2161

December 28, 2025
Tweet

More Decks by nikawa2161

See All by nikawa2161
Node.js Subpath imports
Avatar for nikawa2161 nikawa2161
0
8
Sagaパターン入門（続編）
Avatar for nikawa2161 nikawa2161
0
18
Sagaパターン入門
Avatar for nikawa2161 nikawa2161
0
25
20251209_プログラミング原則の学び
Avatar for nikawa2161 nikawa2161
0
17
自分のコードを数年ぶりに読んだら
Avatar for nikawa2161 nikawa2161
0
12
ユーザーインタビュー分析に参加して得られたことと気づき
Avatar for nikawa2161 nikawa2161
0
11
oEmbedとは？
Avatar for nikawa2161 nikawa2161
0
20
はじめまして、にかわです
Avatar for nikawa2161 nikawa2161
0
13
課題を映す問題空間と、答えを描く解決空間
Avatar for nikawa2161 nikawa2161
0
10

Other Decks in Technology

See All in Technology
越境する組織づくり ─ 多様性を前提にしたチームビルディングとリードの実践知
Avatar for hrpnx kido_engineer
1
110
EMからVPoEを経てCTOへ：マネジメントキャリアパスにおける葛藤と成長
Avatar for KAKEHASHI kakehashi
PRO
7
890
Evolution of Claude Code & How to use features
Avatar for Oikon oikon48
1
280
ヘルシーSRE
Avatar for Hiroki Takatsuka tk3fftk
2
240
AI時代にエンジニアはどう成長すれば良いのか？
Avatar for Recruit recruitengineers
PRO
1
140
Ultra Ethernet (UEC) v1.0 仕様概説
Avatar for Masayuki Kobayashi markunet
3
200
名刺メーカーDevグループ 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
1.1k
Windows ネットワークを再確認する
Avatar for Murachi Akira murachiakira
PRO
0
260
メタデータ同期に潜んでいた問題 〜 Cache Stampede 時の Cycle Wait を⾒つけた話
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
150
型を書かないRuby開発への挑戦
Avatar for Shia riseshia
0
190
Serverless Agent Architecture on Azure / serverless-agent-on-azure
Avatar for miyake miyake
1
150
問い合わせ自動化の技術的挑戦
Avatar for Recruit recruitengineers
PRO
2
150

Featured

See All Featured
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
2
530
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
141
7.3k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
Avatar for Tammy Everts tammyeverts
55
3.3k
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
Avatar for Ines Montani inesmontani
PRO
3
2.1k
Breaking role norms: Why Content Design is so much more than writing copy - Taylor Woolridge
Avatar for UX Y'all uxyall
0
200
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
Designing Powerful Visuals for Engaging Learning
Avatar for Mike Taylor tmiket
0
260
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
666
130k
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.1k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
408
66k
Designing for Performance
Avatar for Lara Hogan lara
611
70k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
6k

Transcript

  1. None
  2. None
  3. None
  4. None
  5. None
  6. None
  7. None
  8. None
  9. None
  10. None
  11. None
  12. None
  13. None
  14. None
  15. None
  16. None
  17. None
  18. None
  19. None
  20. None
  21. None
  22. None

  23. btree_gist

  24. CREATE EXTENSION btree_gist; CREATE TABLE room_reservations ( room_name text, check_in

    timestamp, check_out timestamp ); ALTER TABLE room_reservations ADD CONSTRAINT no_overlapping_reservations EXCLUDE USING gist ( room_name WITH =, tsrange(check_in, check_out) WITH && );

  25. room_name check_in check_out

  26. no_overlapping_reservations

  27. &&

  28. gist ( room_name WITH =, tsrange(check_in, check_out) WITH && );

    room_name WITH = tsrange(check_in, check_out) WITH &&

  29. tsrange check_in check_out

  30. WHERE (start1 < end2) AND (start2 < end1) WHERE period1

    && period2

  31. EXTENSION btree_gist room_name

  32. None

  33. btree_gist

  34. None