摘要: 函数调用, 这个简单 CREATE FUNCTION concat_lower_or_upper(a text, b text, uppercase boolean DEFAULT false) RETURNS text AS $$ SELECT CASE WHEN $3 THEN UPPER($1 || ' ' || $2) ELSE LOWER($1 || '... 阅读全文
posted @ 2016-04-08 16:24 songlihong 阅读(139) 评论(0) 推荐(0) 编辑
摘要: A value expression is one of the following: A constant or literal value A column reference A positional parameter reference, in the body of a function definition or prepared statement A subscripted ex... 阅读全文
posted @ 2016-04-08 15:59 songlihong 阅读(154) 评论(0) 推荐(0) 编辑
摘要: 4.1. Lexical Structure (SQL命令的结构or组成) A token can be akey word, anidentifier, aquoted identifier, aliteral(or constant), or a special character symbol. SQL语句的基本组成 关键字:SELECT, INSERT, UP... 阅读全文
posted @ 2016-04-08 15:31 songlihong 阅读(239) 评论(0) 推荐(0) 编辑