⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 reltime.out

📁 关系型数据库 Postgresql 6.5.2
💻 OUT
字号:
QUERY: CREATE TABLE RELTIME_TBL (f1 reltime);QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 1 minute');QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 5 hour');QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 10 day');QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 34 year');QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 3 months');QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 14 seconds ago');QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('badly formatted reltime');ERROR:  Bad reltime external representation 'badly formatted reltime'QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 30 eons ago');ERROR:  Bad reltime external representation '@ 30 eons ago'QUERY: SELECT '' AS six, RELTIME_TBL.*;six|f1           ---+-------------   |@ 1 min         |@ 5 hours       |@ 10 days       |@ 34 years      |@ 3 mons        |@ 14 secs ago(6 rows)QUERY: SELECT '' AS five, RELTIME_TBL.*   WHERE RELTIME_TBL.f1 <> '@ 10 days'::reltime;five|f1           ----+-------------    |@ 1 min          |@ 5 hours        |@ 34 years       |@ 3 mons         |@ 14 secs ago(5 rows)QUERY: SELECT '' AS three, RELTIME_TBL.*   WHERE RELTIME_TBL.f1 <= '@ 5 hours'::reltime;three|f1           -----+-------------     |@ 1 min           |@ 5 hours         |@ 14 secs ago(3 rows)QUERY: SELECT '' AS three, RELTIME_TBL.*   WHERE RELTIME_TBL.f1 < '@ 1 day'::reltime;three|f1           -----+-------------     |@ 1 min           |@ 5 hours         |@ 14 secs ago(3 rows)QUERY: SELECT '' AS one, RELTIME_TBL.*   WHERE RELTIME_TBL.f1 = '@ 34 years'::reltime;one|f1        ---+----------   |@ 34 years(1 row)QUERY: SELECT '' AS two, RELTIME_TBL.*   WHERE RELTIME_TBL.f1 >= '@ 1 month'::reltime;two|f1        ---+----------   |@ 34 years   |@ 3 mons  (2 rows)QUERY: SELECT '' AS five, RELTIME_TBL.*   WHERE RELTIME_TBL.f1 > '@ 3 seconds ago'::reltime;five|f1        ----+----------    |@ 1 min       |@ 5 hours     |@ 10 days     |@ 34 years    |@ 3 mons  (5 rows)QUERY: SELECT '' AS fifteen, r1.*, r2.*   FROM RELTIME_TBL r1, RELTIME_TBL r2   WHERE r1.f1 > r2.f1   ORDER BY r1.f1, r2.f1;fifteen|f1        |f1           -------+----------+-------------       |@ 1 min   |@ 14 secs ago       |@ 5 hours |@ 14 secs ago       |@ 5 hours |@ 1 min             |@ 10 days |@ 14 secs ago       |@ 10 days |@ 1 min             |@ 10 days |@ 5 hours           |@ 3 mons  |@ 14 secs ago       |@ 3 mons  |@ 1 min             |@ 3 mons  |@ 5 hours           |@ 3 mons  |@ 10 days           |@ 34 years|@ 14 secs ago       |@ 34 years|@ 1 min             |@ 34 years|@ 5 hours           |@ 34 years|@ 10 days           |@ 34 years|@ 3 mons     (15 rows)

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -