[B! &PostgreSQL] sankasekiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sankaseki id:sankaseki

&PostgreSQLã«é–¢ã™ã‚‹sankasekiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

chulip.org
æŽ²é¡Œã®é€šã‚Šã ãŒã€Amazon Aurora MySQL 3ã«ãŠã„ã¦ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§Greenç’°å¢ƒã¸æ›¸ãè¾¼ã¿ãŒè¨±å¯ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã ã€‚ ä¸Šè¨˜RDSã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¯ä¸‹è¨˜ã®è¨˜è¼‰ãŒã‚ã‚‹ã€‚ ãƒ–ãƒ«ãƒ¼/ã‚°ãƒªãƒ¼ãƒ³ãƒ‡ãƒ—ãƒã‚¤ã‚’ä½œæˆã™ã‚‹ã¨ã€ã‚°ãƒªãƒ¼ãƒ³ç’°å¢ƒã® DB ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§èªã¿å–ã‚Šå°‚ç”¨ã«ãªã‚Šã¾ã™ã€‚ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html ãƒ†ã‚¹ãƒˆä¸ã¯ã€ã‚°ãƒªãƒ¼ãƒ³ç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿å–ã‚Šå°‚ç”¨ã«ä¿ã¤ã“ã¨ã‚’ãŠå‹§ã‚ã—ã¾ã™ã€‚ã‚°ãƒªãƒ¼ãƒ³ç’°å¢ƒã§ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ç«¶åˆãŒç™ºç”Ÿã™ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ãŸã‚ã€æ›¸ãè¾¼ã¿æ“ä½œã‚’æœ‰åŠ¹ã«ã™ã‚‹å ´åˆã¯æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ã¾ãŸã€ã‚¹ã‚¤ãƒƒãƒã‚ªãƒ¼ãƒãƒ¼å¾Œã«æœ¬ç¨¼åƒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ„å›³ã—ãªã„ãƒ‡ãƒ¼ã‚¿ãŒç™ºç”Ÿã™ã‚‹å¯èƒ½æ€§ã‚‚ã‚ã‚Šã¾ã™ã€‚RDS for MySQL ã®æ›¸
sankaseki 2009/04/17
[Vim] - WapBox

#vim

.Blog

=å€‹äººã‚µã‚¤ãƒˆ
ãƒªãƒ³ã‚¯
kamoland
AutoHotKeyã‚’ä½¿ã£ã¦ï¼Œã‚ãƒ¼ã‚’æŠ¼ã™ã“ã¨ã§ãƒ¢ãƒ‹ã‚¿ãƒ¼é–“ã®ãƒžã‚¦ã‚¹ã‚«ãƒ¼ã‚½ãƒ«ç§»å‹•ãŒã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨ã„ã†è©±ã§ã™ï¼Ž ãƒ‡ã‚£ã‚¹ãƒ—ãƒ¬ã‚¤ã‚’æ¨ªã«ä¸¦ã¹ã¦3æžšä½¿ã£ã¦ã„ã‚‹ã®ã§ã™ãŒï¼Œãƒžã‚¦ã‚¹ç§»å‹•ãŒï¼Œè·é›¢ãŒé•·ããªã‚Šå°‘ã€…ã‚ã‚“ã©ãã•ã„ã¨ã„ã†ã®ãŒã‚ã‚Šã¾ã™ï¼Ž ã“ã¡ã‚‰ã®ã‚µã‚¤ãƒˆ ãƒˆãƒªãƒ—ãƒ«ãƒ¢ãƒ‹ã‚¿é–“ã®ãƒžã‚¦ã‚¹ç§»å‹•ã‚’ãƒœã‚¿ãƒ³1ã¤ã§å®Ÿç¾ï¼åœ§å€’çš„ã«å¿«é©ãªæ¥å‹™ç’°å¢ƒã®æ§‹ç¯‰ãƒ¡ãƒ¢ ã‚’å‚è€ƒã«ã—ã¦ï¼ŒF1ï¼ŒF4ã‚ãƒ¼ã§å·¦å³ã®ãƒ‡ã‚£ã‚¹ãƒ—ãƒ¬ã‚¤ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹ãŸã‚ã®ï¼ŒAutoHotKeyã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œã‚Šã¾ã—ãŸï¼Ž F1:: SysGet, MonitorC, Monitor, 1 SysGet, MonitorL, Monitor, 3 CoordMode, Mouse, Screen MouseGetPos, x, y If x < %MonitorCRight% MouseMove, (MonitorLLeft + MonitorLRight) / 2, (Monit
sankaseki 2009/02/12
PostgreSQLã§ã®ROWNUMã‚‚ã©ã - ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼'sãƒšã‚¤ã‚¸

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
ã‚µãƒ³ãƒ—ãƒ« SELECTæ–‡
SELECTã€€åˆ—å1ã€€[ AS åˆ¥å1 ]ã€€[ ï¼Œåˆ—å2 [ AS åˆ¥å2 ] â€¦] FROMã€€è¡¨å [ WHEREã€€æ¤œç´¢æ¡ä»¶ ]ï¼› SELECTã€œã¯è¡¨ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢ã‚’è¡Œã†ã€‚åˆ—åã«ã€Œ*ã€ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã§å…¨ã¦ã®åˆ—ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ ã¾ãŸåˆ—å AS åˆ¥åã§æ¤œç´¢çµæžœã®åˆ—è¦‹å‡ºã—ã‚’å¤‰æ›´ã§ãã‚‹ã€‚ï¼ˆASã¯çœç•¥å¯ï¼‰ WHEREã‚’ä»˜åŠ ã™ã‚‹ã“ã¨ã§æ¡ä»¶ã¨ä¸€è‡´ã™ã‚‹ç‰¹å®šã®è¡Œã‚’å–ã‚Šå‡ºã™ã“ã¨ã‚‚ã§ãã‚‹ã€‚ db=# select * from customer ; no | name | age | job | date | mail | contno -----+--------------------+-----+-----------+------------+----------------+-------- 101 | Taro Tanaka | 23 | Finance | 1998-02-20 | ta
sankaseki 2009/02/12
ã‚µãƒ³ãƒ—ãƒ« SELECTæ–‡

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
SQLã®åŸºæœ¬-æ–‡å—åˆ—æ“ä½œé–¢æ•°ç·¨ï¼šè€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®å‚™å¿˜éŒ²ï¼šSo-netãƒ–ãƒã‚°
SQLã®åŸºæœ¬-æ–‡å—åˆ—æ“ä½œé–¢æ•°ç·¨ æ–‡å—åˆ—ã®å€¤ã®èª¿æŸ»ã‚„æ“ä½œã®ãŸã‚ã®é–¢æ•°ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ä½¿ç”¨æ³•ã¯ã€ç‰¹ã«é›£ã—ãã‚‚ãªãå¼•æ•°ã‹ã‚‰é€£æƒ³ã§ãã‚‹ã‚‚ã®ã°ã‹ã‚Šãªã®ã§ã‚µãƒ³ãƒ—ãƒ«ã¯ä¸è¦ã¨ã—ã¾ã—ãŸã€‚ ãƒ»æ–‡å—ã‚’æ–‡å—ã‚³ãƒ¼ãƒ‰ã«å¤‰æ›(æœ€åˆã®1ãƒã‚¤ãƒˆ) Oracle MySQL PostgreSQL SQL Server ASCII(æ–‡å—åˆ—) ASCII(æ–‡å—åˆ—) HEX(æ–‡å—åˆ—å¼) 16é€²ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™ ASCII(æ–‡å—åˆ—) ASCII(æ–‡å—åˆ—) UNICODE(æ–‡å—åˆ—) ãƒ»æ•°å€¤ã‚’æ–‡å—ã«å¤‰æ› Oracle MySQL PostgreSQL SQL Server HEX(16é€²æ•°å€¤) STR(æ•°å€¤, æ¡æ•°, å°æ•°ç‚¹ä»¥ä¸‹ã®æ¡æ•°) ãƒ»æ–‡å—åˆ—ã®ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—è¡¨ç¾ æ–‡å—åˆ—å†…ã®å¼•ç”¨ç¬¦ã‚„ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãŒSQLã§å‡¦ç†ã•ã‚Œã‚‹ã‚ˆã†ã«æ–‡å—åˆ—ã‚’ä½œæˆã™ã‚‹ã€‚ Oracle MySQL PostgreSQL SQL Server QUOTE(æ–‡å—åˆ—
sankaseki 2009/02/12
SQLã®åŸºæœ¬-æ–‡å—åˆ—æ“ä½œé–¢æ•°ç·¨ï¼šè€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®å‚™å¿˜éŒ²ï¼šSo-net blog

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
PostgreSQLãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹
sankaseki 2009/02/12
PostgreSQLãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
SQLã®åŸºæœ¬-æ¼”ç®—åï¼šè€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®å‚™å¿˜éŒ²ï¼šSo-netãƒ–ãƒã‚°
SQLã®æ¼”ç®—å SELECTåŠã³WHEREå¥ã«æŒ‡å®šã™ã‚‹ã“ã¨ãŒå¯èƒ½ãªæ¼”ç®—å æ€ã„ã®ã»ã‹ä¾¿åˆ©ãªæ¼”ç®—åãŒæƒã£ã¦ã„ã¾ã™ã€‚ ãƒ»æ•°å€¤åŠã³æ—¥ä»˜ã®åŠ æ¸›ä¹—é™¤æ¼”ç®— å„ªå…ˆé †ä½ * åŒä¸€ã®å„ªå…ˆé †ä½ã«ã‚ã‚‹æ¼”ç®—åã¯å·¦ã‹ã‚‰é †ã«è¨ˆç®— * ã‚«ãƒƒã‚³å†…ã«ã‚ã‚‹æ¼”ç®—åã¯æœ€åˆã«è¨ˆç®— * ä¹—ç®—ã€é™¤ç®—ã€å‰°ä½™æ¼”ç®—åã®æ¬¡ã«åŠ ç®—ã€æ¸›ç®—ã‚’è¨ˆç®— å¼ çµæžœ æ•°å€¤ + æ•°å€¤ æ•°å€¤ æ—¥ä»˜ + æ•°å€¤ æ—¥ä»˜ æ—¥ä»˜ + æœŸé–“ æ—¥ä»˜ æ•°å€¤ - æ•°å€¤ æ•°å€¤ æ—¥ä»˜ - æ•°å€¤ æ—¥ä»˜ æ—¥ä»˜ - æœŸé–“ æ—¥ä»˜ æ•°å€¤ - æ—¥ä»˜ æ•°å€¤ æ•°å€¤ * æ•°å€¤ æ•°å€¤ æ•°å€¤ / æ•°å€¤ æ•°å€¤ æ•°å€¤ % æ•°å€¤ ä½™ã‚Š (SQL Server,MySQL,PostgreSQL) ãƒ»æ–‡å—åˆ—ã®çµåˆ æ–‡å—åˆ—å¼1 || æ–‡å—åˆ—å¼2 = æ–‡å—åˆ—å¼1æ–‡å—åˆ—å¼2 ï¼ˆOracle,PostgreSQLï¼‰ æ–‡å—åˆ—å¼1 + æ–‡å—åˆ—å¼2 = æ–‡å—åˆ—å¼1æ–‡å—åˆ—å¼2 ï¼ˆSQL Serverï¼‰ ãƒ»å˜é …æ¼”ç®—å +å¼ å¼ã®ç¬¦å·
sankaseki 2009/02/12
SQLã®åŸºæœ¬-æ¼”ç®—åï¼šè€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®å‚™å¿˜éŒ²ï¼šSo-net blog

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
PostgreSQL 8.3.7æ–‡æ›¸
ç›®æ¬¡ã¯ã˜ã‚ã«PostgreSQLã¨ã¯?PostgreSQLå°å²è¦ç´„ã‚ˆã‚Šé€²ã‚“ã æƒ…å ±ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³I. ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«1ç« ã•ã‚å§‹ã‚ã¾ã—ã‚‡ã†2ç« SQLè¨€èªž3ç« é«˜åº¦ãªè«¸æ©Ÿèƒ½II. SQLè¨€èªž4ç« SQLã®æ§‹æ–‡5ç« ãƒ‡ãƒ¼ã‚¿å®šç¾©6ç« ãƒ‡ãƒ¼ã‚¿æ“ä½œ7ç« å•ã„åˆã‚ã›8ç« ãƒ‡ãƒ¼ã‚¿åž‹9ç« é–¢æ•°ã¨æ¼”ç®—å10ç« åž‹å¤‰æ›11ç« ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹12ç« å…¨æ–‡æ¤œç´¢13ç« åŒæ™‚å®Ÿè¡Œåˆ¶å¾¡14ç« æ€§èƒ½ã«é–¢ã™ã‚‹ãƒ’ãƒ³ãƒˆIII. ã‚µãƒ¼ãƒã®ç®¡ç†15ç« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †16ç« Windowsã«ãŠã‘ã‚‹ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«17ç« ã‚ªãƒšãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ã®ç’°å¢ƒ18ç« ã‚µãƒ¼ãƒã®æ§‹æˆ19ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒ¼ãƒ«ã¨æ¨©é™20ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†21ç« ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆèªè¨¼22ç« å¤šè¨€èªžå¯¾å¿œ23ç« å®šå¸¸çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¿å®ˆä½œæ¥24ç« ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢25ç« é«˜å¯ç”¨æ€§ã€è² è·åˆ†æ•£ãŠã‚ˆã³ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³26ç« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ´»å‹•çŠ¶æ³ã®ç›£è¦–27ç« ãƒ‡ã‚£ã‚¹ã‚¯ä½¿ç”¨é‡ã®ç›£è¦–28ç« ä¿¡é ¼æ€§ã¨ãƒã‚°å…ˆè¡Œæ›¸ãè¾¼ã¿29ç« ãƒªã‚°ãƒ¬
sankaseki 2009/02/12
PostgreSQL 8.3.5æ–‡æ›¸

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
PostgreSQL 7.3.4 ãƒ¦ãƒ¼ã‚¶ã‚¬ã‚¤ãƒ‰
PostgreSQL 7.3.4 ãƒ¦ãƒ¼ã‚¶ã‚¬ã‚¤ãƒ‰PostgreSQL ã‚°ãƒãƒ¼ãƒãƒ«é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ—Copyright Â© 1996-2002 by PostgreSQL ã‚°ãƒãƒ¼ãƒãƒ«é–‹ç™ºã‚°ãƒ«ãƒ¼ãƒ— Table of Contentsã¯ã˜ã‚ã«1. PostgreSQLã¨ã¯?2. PostgreSQL å°å²2.1. ãƒãƒ¼ã‚¯ãƒ¬ã‚¤æ ¡ POSTGRES ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ2.2. Postgres952.3. PostgreSQL3. æœ¬æ›¸ã®æ§‹æˆ4. ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒªã‚½ãƒ¼ã‚¹ã®æ¦‚è¦5. ç”¨èªžã¨è¡¨è¨˜6. ãƒã‚°ãƒ¬ãƒãƒ¼ãƒˆã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³6.1. ãƒã‚°ã®ç‰¹å®š6.2. å ±å‘Šã™ã¹ãã“ã¨6.3. ãƒã‚°å ±å‘Šå…ˆ1. SQLã®æ§‹æ–‡1.1. èªžå½™ã®æ§‹æˆ1.1.1. è˜åˆ¥åã¨ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰1.1.2. å®šæ•°1.1.3. æ¼”ç®—å1.1.4. ç‰¹æ®Šæ–‡å—1.1.5. ã‚³ãƒ¡ãƒ³ãƒˆ1.1.6. èªžå½™ã®å„ªå…ˆé †ä½1.2. è©•ä¾¡å¼1.2.1. åˆ—ã®å‚ç…§1.2.2. ä½ç½®
sankaseki 2009/02/12
PostgreSQL 7.3.2 ãƒ¦ãƒ¼ã‚¶ã‚¬ã‚¤ãƒ‰

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
SQLServerã®TOP MySQLã€PostgreSQLã§ã¯LIMITã€OFFSETã€€IT Tips
SQLServerã§ã¯ SELECT TOP 1 * FROM sample; ã§æ¤œç´¢çµæžœã®1è¡Œç›®ã‚’å–å¾—ã§ãã¾ã™ãŒ MySQLã‚„PostgreSQLã«ã¯ãã‚ŒãŒã‚ã‚Šã¾ã›ã‚“ã®ã§ ä»¥ä¸‹ã®ã‚ˆã†ã«å–å¾—ã—ã¾ã™ æ¤œç´¢çµæžœã®1è¡Œç›®ï¼ˆã‚ªãƒ•ã‚»ãƒƒãƒˆ0ï¼‰ã‹ã‚‰ã€1è¡Œã‚’å–å¾—ã®ä¾‹ [MySQL] SELECT * FROM sample LIMIT 0, 1; [PostgreSQL] SELECT * FROM sample LIMIT 1 OFFSET 0; æ¤œç´¢çµæžœã®3è¡Œç›®ï¼ˆã‚ªãƒ•ã‚»ãƒƒãƒˆ2ï¼‰ã‹ã‚‰ã€4è¡Œã‚’å–å¾—ã®ä¾‹ [MySQL] SELECT * FROM sample LIMIT 2, 4; [PostgreSQL] SELECT * FROM sample LIMIT 4 OFFSET 2;
sankaseki 2009/02/12
SQLServerã®TOP MySQLã€PostgreSQLã§ã¯LIMITã€OFFSETã€€IT Tips

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
PostgreSQL ç·¨9 - ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•ã„åˆã‚ã›ã€ä»¶æ•°æŒ‡å®šã€OFFSETã€LIMITã€HAVING - SAK Streets
PostgreSQL ç·¨9 - ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•ã„åˆã‚ã›ã€ä»¶æ•°æŒ‡å®šã€OFFSETã€LIMITã€HAVING â– ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•ã„åˆã‚ã› ãƒ»PostgreSQL ã§ã‚‚ã€ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•ã„åˆã‚ã›ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€‚ ã“ã®ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•ã„åˆã‚ã›ã¯ã€åºƒãå¿œç”¨ã§ãã¦éžå¸¸ã«ä¾¿åˆ©ã§ã™ã€‚ å°šã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãªã©å˜ä¸€è¡Œã®çµæžœã‚’æˆ»ã™å¿…è¦ã®ã‚ã‚‹å•ã„åˆã‚ã›ã‚’ å˜ä¸€è¡Œå‰¯å•ã„åˆã‚ã›ã¨å‘¼ã¶ã€‚ (å˜1è¡Œå‰¯å•ã„åˆã‚ã›ã€å˜ä¸€è¡Œå•ã„åˆã‚ã›ã€å˜1è¡Œå•ã„åˆã‚ã›) select key, (select key from testm b where key = a.code1) from test2m a ; key | ?column? ----------+---------- abc01 | a001 abc02 | a011 abc03 | abc02 | a011 abc03 | â– ã‚¤ãƒ³ãƒ©ã‚¤ãƒ³ãƒ“ãƒ¥ãƒ¼ ãƒ»ã‚¤ãƒ³ãƒ©ã‚¤ãƒ³ãƒ“ãƒ¥ãƒ¼ã¯ã€æ¬¡ã®ã‚ˆã†ã«ã™ã‚‹ã€‚
sankaseki 2009/02/12
PostgreSQL ç·¨9 - ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•ã„åˆã‚ã›ã€ä»¶æ•°æŒ‡å®šã€OFFSETã€LIMITã€HAVING - SAK Streets

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºï¼šç¬¬1å›žã€€PostgreSQLã§å¦ã¶SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œ (1/15)
ç‰¹é›†ã€€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ä½œã‚‹Java+DB ç¬¬1å›žã€€PostgreSQLã§å¦ã¶SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œ (1/15) ãƒ“ã‚¸ãƒã‚¹ç³»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ ¼ç´ã¨ã—ã¦ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ã‚’ä½¿ã†ã“ã¨ãŒã»ã¨ã‚“ã©ã ã€‚ã“ã®éš›ã«åˆ©ç”¨ã™ã‚‹ã®ãŒã€ŒSQLã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžã€‚ã“ã®ç‰¹é›†ã§ã¯PostgreSQLã‚’æŒ™ã’ã¦æ“ä½œæ–¹æ³•ã‚’è§£èª¬ã—ã¦ã„ãã€‚ ã“ã®ç‰¹é›†ã€Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ä½œã‚‹Javaï¼‹DBã€ã¯ã€ã€ŒTomcatã§çŸ¥ã‚‹JSP/ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã®åŸºç¤Žã€ã®å»¶é•·ã¨ã—ã¦ä½ç½®ã¥ã‘ã‚‹ã‚‚ã®ã ã€‚ç¬¬2å›žã§ã¯ã€Tomcatï¼ˆJSPï¼‰ã¨ã®é€£æºè§£èª¬ã‚’è¡Œã£ã¦ã„ãã€‚ PostgreSQLã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¹ãƒˆã‚¢ã™ã‚‹ã ã‘ã§ãªãã€åˆ¶ç´„ã®è¨å®šã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ“ä½œã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®æ©Ÿèƒ½ã‚‚å‚™ãˆã€ã‹ãªã‚Šæœ¬æ ¼æ´¾ã§ã‚ã‚‹ã€‚ã¾ãŸã€PostgreSQLã¯ã€Cã€C++ã€Javaã€Perlã€Tclã€Pythonãªã©å¤šæ•°ã®é–‹
sankaseki 2009/02/12
ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºï¼šç¬¬1å›žã€€PostgreSQLã§å¦ã¶SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œ (1/15)

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
LIMITã¨OFFSET
4.6. LIMITã¨OFFSET LIMIT ãŠã‚ˆã³ OFFSET ã‚’ä½¿ã†ã“ã¨ã§ã€å•ã„åˆã‚ã›ã®å®Ÿè¡Œã§ç”Ÿæˆã•ã‚ŒãŸè¡Œã®ä¸€éƒ¨ã ã‘ã‚’å–ã‚Šå‡ºã™ã“ã¨ãŒã§ãã¾ã™ã€‚ SELECT select_list FROM table_expression [LIMIT { number | ALL }] [OFFSET number] é™åº¦æ•° (LIMIT) ã‚’æŒ‡å®šã™ã‚‹ã¨ã€æŒ‡å®šã—ãŸè¡Œæ•°ã‚ˆã‚Šå¤šãã®è¡ŒãŒè¿”ã•ã‚Œã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ (å•ã„åˆã‚ã›ã®çµæžœã«ã‚ˆã£ã¦ã€æŒ‡å®šã‚ˆã‚Šå°‘ãªã„ã“ã¨ã¯ã‚ã‚Šã¾ã™)ã€‚ LIMIT ALL ã¯ã€LIMIT å¥ã‚’çœç•¥ã—ãŸå ´åˆã¨åŒã˜ã§ã™ã€‚ OFFSET ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¸è¿”ã™è¡Œã®é–‹å§‹ä½ç½®ã‚’é£›ã°ã™è¡Œæ•°ã‚’æŒ‡å®šã—ã¾ã™ã€‚ OFFSET 0 ã¯ã€OFFSET å¥ã‚’çœç•¥ã—ãŸå ´åˆã¨åŒã˜ã§ã™ã€‚ OFFSET ãŠã‚ˆã³ LIMIT ã®ä¸¡è€…ãŒæŒ‡å®šã•ã‚ŒãŸå ´åˆã€OFFSET æ–‡ã®è¡Œã‚’ã‚¹ã‚ãƒƒãƒ—ã—ã¦ã‹ã‚‰ã€è¿”ã•ã‚Œã‚‹ LIMIT è¡Œã‚’
sankaseki 2009/02/12
LIMITã¨OFFSET

&PostgreSQL

.Tips
ãƒªãƒ³ã‚¯
PostgreSQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
å‚è€ƒWebãƒšãƒ¼ã‚¸: http://www.hizlab.net/app/pgsql.html http://www.stackasterisk.jp/tech/dataBase/postgresql02_01.jsp PostgreSQL Web ãƒšãƒ¼ã‚¸: http://www.postgresql.org/ ã‚«ãƒ¼ãƒãƒ«è¨å®š: http://www.postgresql.jp/document/pg813doc/html/kernel-resources.html ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«: http://www.postgresql.jp/document/pg813doc/html/installation.html Apache + PHP + PostgreSQL å®Ÿé¨“å®¤: http://www.hizlab.net/app/index.html WEB+DBãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° Apache+P
sankaseki 2008/12/22
PostgreSQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

&PostgreSQL

&JDBC

.Tips
ãƒªãƒ³ã‚¯
Linux ã¨PostgreSQL ã§JDBC
sankaseki 2008/12/22
Linux ã¨PostgreSQL ã§JDBC

&PostgreSQL

&JDBC

.Tips
ãƒªãƒ³ã‚¯
PostgreSQLã«ã¤ã„ã¦
PostgreSQLã¨ã¯ã€SQLã§ã‚¢ã‚¯ã‚»ã‚¹ãŒå¯èƒ½ãªã€ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä»¥ä¸‹ã«ã€PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ JDBCãƒ‰ãƒ©ã‚¤ãƒã‚„ã€DBD/DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†å ´åˆãªã©ã¯ã€ã‚½ãƒ¼ã‚¹ã‹ã‚‰ãƒ¡ã‚¤ã‚¯ã—ã¾ã™ã€‚ å…¥æ‰‹å…ƒ URL
sankaseki 2008/12/22
PostgreSQLã«ã¤ã„ã¦

&PostgreSQL

.install|å°Žå…¥|æ§‹ç¯‰

.Tips
ãƒªãƒ³ã‚¯
PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«(FreeBSD,Solaris,Linux)
PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ ã™ã€‚ Linux,Solaris,FreeBSDã®å„OSã«ã¦å¿œç”¨ã§ãã¾ã™ã€‚ å„OSã§ã®é•ã„ã¯ã€ãã®ã¤ã©è¨˜è¼‰ã—ã¾ã™ã€‚ JDBCãƒ‰ãƒ©ã‚¤ãƒã¨ã€PGAccess(GUIç®¡ç†)ã‚‚ä¸€æ‰€ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ PostgreSQLã®ã‚½ãƒ¼ã‚¹ã¯ã“ã¡ã‚‰ã‹ã‚‰ã€‚ ä»Šå›žã¯ã€PostgreSQL-7.3.4.tar.gzã‚’ä½¿ç”¨ã€‚ ã¾ãšã¯ã€ä»¥ä¸‹ã®ç‰©ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã‹ç¢ºèªã—ã¦ãã ã•ã„ã€‚ J2SDK1.3 or 1.4 automake autoconf libtool gmake(make) gcc readline Tcl Tk apache-ant ï¼ŠLinuxã®ä¸€èˆ¬çš„ãªãƒ‡ã‚£ã‚¹ãƒˆãƒª ãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ã ã„ãŸã„å…¥ã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚FreeBSDã‚„Solarisã§ã¯åˆ¥é€”ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ãŸã€TurboLinux
sankaseki 2008/12/22
PostgreSQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«(FreeBSD,Solaris,Linux)

&PostgreSQL

.install|å°Žå…¥|æ§‹ç¯‰

.Tips
ãƒªãƒ³ã‚¯
â– - æˆ¯è¨€æ—¥å ± in ã¯ã¦ãª
Ubuntuä¸Šã§PostgreSQL 8.3.5ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« â—‹å‰æº–å‚™ ãƒ»ã‚°ãƒ«ãƒ¼ãƒ—ä½œæˆ groupadd postgres ãƒ»ãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆ useradd -g postgres postgres -s /bin/bash passwd postgres ãƒ»ãƒ›ãƒ¼ãƒ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œæˆ mkdir /home/postgres chown postgres.postgres chmod g=+rwx /home/postgres â€»ãƒ›ãƒ¼ãƒ ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä½œæˆã¾ã§å®Œäº†ã—ãŸã‚‰ã€ä¸€åº¦ã€ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã§ã€ãƒã‚°ã‚¤ãƒ³ã—ã¦ã¿ã‚‹ ãƒ»ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ç’°å¢ƒå¤‰æ•°è¨å®š /home/postgresä¸‹ã« .bashrc ä½œæˆ export PATH=$PATH:/usr/local/pgsql/8.3.5/bin export MANPATH=$MANPATH:/usr/local/pgsql/8.3.5/man export P
sankaseki 2008/12/22
PostgreSQL 8.3.5ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - æˆ¯è¨€æ—¥å ± in ã¯ã¦ãª

&PostgreSQL

.install|å°Žå…¥|æ§‹ç¯‰

.Tips
ãƒªãƒ³ã‚¯
PostgreSQLã®JDBCã®è¨å®š
äº‹å‰æº–å‚™ JDBCãƒ‰ãƒ©ã‚¤ãƒã‚’ä½¿ã†ãŸã‚ã«ã¯ã€JDKã¨ã€PostgreSQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ JDK1.1ã®å ´åˆã¯ã€JDBC1.0ã—ã‹ä½¿ãˆã¾ã›ã‚“ã€‚ ã§ã™ã‹ã‚‰ã€JDBC2.0ã‚’ä½¿ã†å ´åˆã¯ã€JDK1.2ä»¥ä¸Šã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ JDBCãƒ‰ãƒ©ã‚¤ãƒã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Javaç”¨ã®JDBCãƒ‰ãƒ©ã‚¤ãƒã¯ã€è‡ªå‹•çš„ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œãªã„ã®ã§ã€åˆ¥é€”ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ JDBCãƒ‰ãƒ©ã‚¤ãƒã«ã¯ã€1.0ã¨2.0ãŒã‚ã‚Šã¾ã™ãŒã€FreeBSDã§ã¯ã€JDK1.1.8ãªã®ã§ã€JDBC1.0ã‚’ä½¿ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã¾ãŸã€JDBCãƒ‰ãƒ©ã‚¤ãƒã®ãƒ¡ã‚¤ã‚¯ã«ã¯ã€ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«CLASSPATHã‚’è¨å®šã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ unix# cd src/interface/jdbc unix# setenv CLASSPATH "${CLASSPATH}:." unix# gmake jdb
sankaseki 2008/12/22
PostgreSQLã®JDBCã®è¨å®š

&PostgreSQL

&JDBC

.install|å°Žå…¥|æ§‹ç¯‰

.Tips
ãƒªãƒ³ã‚¯
http://old.postgresql.jp/wg/jpugdoc/jdbc/jdbc-8.3dev-600/jdbc.html
sankaseki 2008/12/22
PostgreSQL JDBC ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹

&PostgreSQL

&JDBC
ãƒªãƒ³ã‚¯
ã€èª¿æŸ»ã€‘postgresã®JDBCãƒ‰ãƒ©ã‚¤ãƒã¯ã©ã‚Œã‚’ä½¿ãˆã°è‰¯ã„ï¼Ÿ - kounan13ã®æ—¥è¨˜
ã€çµè«–ã€‘JDK1.5ãªã‚‰JDBC3ã€JDK1.6ãªã‚‰JDBC 4 http://jdbc.postgresql.org/download.html JDK 1.1 - JDBC 1. Note that with the 8.0 release JDBC 1 support has been removed, so look to update your JDK when you update your server. JDK 1.2, 1.3 - JDBC 2. JDK 1.3 + J2EE - JDBC 2 EE. This contains additional support for javax.sql classes. JDK 1.4, 1.5 - JDBC 3. This contains support for SSL and javax.sql, but does not
sankaseki 2008/12/22
ã€èª¿æŸ»ã€‘postgresã®JDBCãƒ‰ãƒ©ã‚¤ãƒã¯ã©ã‚Œã‚’ä½¿ãˆã°è‰¯ã„ï¼Ÿ - kounan13ã®æ—¥è¨˜

&PostgreSQL

&JDBC

.Tips
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸