2012年12月_波特王子

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

转载 The Sociolinguistic Variable

1 Labovian MethodologyThe sociolinguistic variable is, Fasold (1990) says, a set of alternative ways of saying the same thing, although the alternatives, or variants, have social significance. Mor

2012-12-31 09:22:55 894

转载 Variation (linguistics)

Variation (linguistics)From Wikipedia, the free encyclopediaIn sociolinguistics, variation in language use among speakers or groups of speakers is a principal concern. Such variation m

2012-12-31 00:17:39 1551

转载 postgresql常用函数汇总

函数：string || string　说明：String concatenation 字符串连接操作例子：'Post' || 'greSQL'　＝　PostgreSQL 函数：string || non-string or non-string || string说明：String concatenation with one non-string input 字符串

2012-12-24 17:43:55 1091

原创 cmd for 数字枚举

for /f "tokens=1,2* delims=." %%a in (list\table.lst) do ( for /l %%n in (1 1 12) do if %%n LEQ 9 ( echo %%a.%%b110%%n ) else ( echo %%a.%%b11%%n ) )

2012-12-24 17:37:07 727

转载 Apparent-time hypothesis

In sociolinguistics, the apparent-time hypothesis(显象时间假设) states that age-stratified(年龄分层) variation in a linguistic form is often indicative of a change in progress. That is, if in a survey of a po

2012-12-24 01:43:30 1238

原创从Greenplum中查询用户名

SELECT u.usename AS "User name", u.usesysid AS "User ID", CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, createdatabase' AS pg_catalog.text) WHEN u.usesuper THEN CAST('superu

2012-12-21 11:11:18 4233

转载 postgres function: COALESCE

COALESCECOALESCE(value [, ...])The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute a defa

2012-12-20 17:30:28 2789

原创 GP中查询表和视图清单，视图的字段及其类型

查询schema_name.view_name的字段及其类型：select a.attname, pg_catalog.format_type(a.atttypid, a.atttypmod) as type,a.attnotnullfrom pg_catalog.pg_attribute a,pg_catalog.pg_class c, pg_catalog.pg_namespace n

2012-12-18 17:21:26 8003

转载 left join 和 left outer join 的区别

来源：http://www.cnblogs.com/cy163/archive/2008/10/16/1312920.htmlleft join 和 left outer join 的区别通俗的讲： A left join B 的连接的记录数与A表的记录数同 A right join B 的连接的记录数与B表的记录数同

2012-12-18 16:24:40 645

转载英文书籍下载网站推荐

http://en.bookfi.org近来下载了很多英文书籍，分享一下自己的下载心得，希望对书友有好处。以前常常抱怨由于老外版权意识强，读英语原版书籍难。后来有机会认识了rapidshare，很多新书都能够找到下载，才恍然大悟：并不是找不到书籍阅读，而是没有找到方法。当然并非所有图书都可以在网上免费下载，能免费下载的是少数，一般而言，畅销书、计算机类图书比较多。但是这

2012-12-15 23:04:50 2372

原创在DOS脚本中加入计数器

@echo off & setlocal EnableDelayedExpansionset count=0for /f "tokens=1,2* delims=." %%a in (not_in_final.lst) do set /a COUNT+=1 & echo insert into myschema.tablename values ('!COUNT!', '%%a', '%%b

2012-12-15 22:41:59 2103

转载 Teradata SQL 笔记

HELP 帮助用户了解数据库中各种对象的结构 SHOW 帮助用户了解某种对象的定义，即返回其DDL语句 EXPLAIN 返回一个SQL语句经优化处理后的执行步骤，注意并未真正执行 FALLBACK 对数据加以保护的一种方式，是冗余的备份 RENAME 对表重命名 NULLIFZERO 对数据作累计处理时，忽略零值 ZEROIFNULL 对数据作累计处理时，将空值作零处理

2012-12-06 10:45:18 803