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

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

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for nikawa2161 nikawa2161
December 28, 2025
Technology
0
24

 沖縄観光と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
11
Sagaパターン入門（続編）
Avatar for nikawa2161 nikawa2161
0
22
Sagaパターン入門
Avatar for nikawa2161 nikawa2161
0
29
20251209_プログラミング原則の学び
Avatar for nikawa2161 nikawa2161
0
19
自分のコードを数年ぶりに読んだら
Avatar for nikawa2161 nikawa2161
0
14
ユーザーインタビュー分析に参加して得られたことと気づき
Avatar for nikawa2161 nikawa2161
0
16
oEmbedとは？
Avatar for nikawa2161 nikawa2161
0
29
はじめまして、にかわです
Avatar for nikawa2161 nikawa2161
0
14
課題を映す問題空間と、答えを描く解決空間
Avatar for nikawa2161 nikawa2161
0
10

Other Decks in Technology

See All in Technology
「通るまでRe-run」から卒業！落ちないテストを書く勘所
Avatar for asumikam asumikam
2
490
新規事業×QAの挑戦：不確実性を乗りこなす！フェーズごとに求められるQAの役割変革
Avatar for hacomono Inc. hacomono
PRO
0
180
Laravelで学ぶOAuthとOpenID Connectの基礎と実装
Avatar for Koji Yoshida kyoshidaxx
4
1.8k
GitHub Copilot CLI で Azure Portal to Bicep
Avatar for Yuta Matsumura tsubakimoto_s
0
190
Physical AI on AWS リファレンスアーキテクチャ / Physical AI on AWS Reference Architecture
Avatar for shota aws_shota
1
130
Copilot 宇宙へ　〜生成AIで「専門データの壁」を壊す方法〜
Avatar for なかしょ nakasho
0
190
AIエージェント×GitHubで実現するQAナレッジの資産化と業務活用 / QA Knowledge as Assets with AI Agents & GitHub
Avatar for Hitsuji tknw_hitsuji
0
230
20260320_JaSST26_Tokyo_登壇資料.pdf
Avatar for Shin Murakami mura_shin
0
120
20年以上続く PHP 大規模プロダクトを Kubernetes へ ── クラウド基盤刷新プロジェクトの4年間
Avatar for Yuichi Sugiyama oogfranz
PRO
0
250
AI時代のオンプレ-クラウドキャリアチェンジ考
Avatar for Yutaro Shirayama yuu0w0yuu
0
230
Agent Skill 是什麼？對軟體產業帶來的變化
Avatar for Bo-Yi Wu appleboy
0
230
Astro Islandsの 内部実装を 「日本で一番わかりやすく」 ざっくり解説！
Avatar for Wu Kenji knj
1
280

Featured

See All Featured
Color Theory Basics | Prateek | Gurzu
Avatar for Gurzu gurzu
0
260
Prompt Engineering for Job Search
Avatar for Mfonobong Umondia mfonobong
0
220
Stewardship and Sustainability of Urban and Community Forests
Avatar for Eric Wiseman pwiseman
0
160
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
950
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
150
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
0
450
What the history of the web can teach us about the future of AI
Avatar for Ines Montani inesmontani
PRO
1
490
Highjacked: Video Game Concept Design
Avatar for Ryan Kendrick rkendrick25
PRO
1
330
Agile that works and the tools we love
Avatar for Rasmus Luckow-Nielsen rasmusluckow
331
21k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.7k
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
274
21k
So, you think you're a good person
Avatar for Per Axbom axbom
PRO
2
2k

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