从HGDB 1.3版本开始,瀚高数据库中添加了dual表
来源:互联网 发布:淘宝上的silkn是真的吗 编辑:程序博客网 时间:2024/05/21 17:43
从HGDB 1.3版本开始,瀚高数据库中添加了dual表:
highgo=# select version() from dual;
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=# select version();
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=#
highgo=# select 1+1 AAA from dual;
aaa
-----
2
(1 row)
highgo=# select 1+1 "AAA" from dual;
AAA
-----
2
(1 row)
highgo=# select 1+1 as "AAA" from dual;
AAA
-----
2
(1 row)
========================================================================================================
postgres9.6@[local]:5432 postgres# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Time: 13.233 ms
postgres9.6@[local]:5432 postgres# select 1+1 as AAA;
aaa
-----
2
(1 row)
Time: 9.708 ms
postgres9.6@[local]:5432 postgres# select 1+1 "AAA";
AAA
-----
2
(1 row)
Time: 0.222 ms
postgres9.6@[local]:5432 postgres# select 1+1 as AAA from dual;
ERROR: relation "dual" does not exist
LINE 1: select 1+1 as AAA from dual;
^
Time: 0.236 ms
highgo=# select version() from dual;
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=# select version();
version
------------------------------------
HighGo Database 3.0.2 Linux 64-bit
(1 row)
highgo=#
highgo=# select 1+1 AAA from dual;
aaa
-----
2
(1 row)
highgo=# select 1+1 "AAA" from dual;
AAA
-----
2
(1 row)
highgo=# select 1+1 as "AAA" from dual;
AAA
-----
2
(1 row)
========================================================================================================
postgres9.6@[local]:5432 postgres# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Time: 13.233 ms
postgres9.6@[local]:5432 postgres# select 1+1 as AAA;
aaa
-----
2
(1 row)
Time: 9.708 ms
postgres9.6@[local]:5432 postgres# select 1+1 "AAA";
AAA
-----
2
(1 row)
Time: 0.222 ms
postgres9.6@[local]:5432 postgres# select 1+1 as AAA from dual;
ERROR: relation "dual" does not exist
LINE 1: select 1+1 as AAA from dual;
^
Time: 0.236 ms
阅读全文
0 0
- 从HGDB 1.3版本开始,瀚高数据库中添加了dual表
- HGDB PG表中添加删除列
- HGDB与oracle中dual的区别
- 瀚高数据库(HGDB 3.1.4)常用管理命令
- HGDB瀚高数据库各进制之间的转换
- HGDB表中修改默认值
- 瀚高数据库(HGDB)不同schema间的数据迁移
- ORACLE数据库中dual虚拟表简介
- SQLServer数据库从高版本降级到低版本
- SQL Server 数据库从高版本附加到低版本
- SQL Server 数据库从高版本附加到低版本
- SQL数据库从高版本导入低版本
- 详解Oracle数据库中DUAL表的使用
- 详解Oracle数据库中DUAL表的使用
- 详解Oracle数据库中DUAL表的使用
- oracle 数据库中dual虚拟表的介绍
- 文章标题 Oracle数据库中dual表使用
- Oracle中dual表
- mysql for mac修改初始密码
- codeforces 498C C. Array and Operations(最大流+数论)
- linux命令_系统管理_passwd
- python技巧一
- centos7配置yum源
- 从HGDB 1.3版本开始,瀚高数据库中添加了dual表
- SVN服务器搭建(保证一次成功配置)
- Win10 下安装 Android开发环境(AndroidStudio)
- 数据库的练习
- 作业二十八 单词拼接
- MPLS 工作原理
- 226. Invert Binary Tree
- [leetcode-9] Palindrome Number
- tomcat启动不来(部署项目跑不起来,单独可以启动)