bielidefeng的专栏

java如何将unicode的char转换为bytes即对应于C++中的charprivate boolean is_halfshaped(char uchar){ byte[] bytes = new byte[0]; try { bytes = String.valueOf(uchar).getBytes("GBK"); } catch (Unsupp...

------------查看eclipse或者myeclipse的话，鼠标放到想查看的类上，按F4。

http://blog.163.com/digoal@126/blog/static/163877040201062944945126/

http://blog.163.com/digoal@126/blog/static/16387704020121125113226736/调用gdb编译需要在cc后面加 -g参数再加-o；[root@redhat home]#gdb 调试文件：启动gdb(gdb) l ：（字母l）从第一行开始列出源码(gdb) break n :在第n行处设置断点(gdb) brea

http://my.oschina.net/Kenyon/blog/214953

http://blog.csdn.net/bhq2010/article/details/12200533http://wiki.postgresql.org/wiki/Pgsrcstructure

http://blog.csdn.net/tianlianchao1982/article/details/11557099

ubuntu追加空间http://blog.csdn.net/openme_openwrt/article/details/8099956-------------------播放视频avi等使用SMPLAYER播放器-----------终端目录的说明使用“/usr/.....”===>系统目录使用“~/桌面/...”===

----------ps -ewf显示所有进程，ps -a|grep ss指的是显示ss关键字的所有进程。top是动态显示进程。---------cat直接将文件内容显示在终端上。---------查看linux系统版本信息cat /etc/*release。---------从一台Linux机子拷贝recovery.conf.sample到192.168.59.128

http://blog.163.com/digoal@126/blog/static/16387704020131410250983/http://www.cnblogs.com/gaojian/archive/2013/08/07/3243045.html

http://www.postgresql.org/docs/9.3/static/tablefunc.html安装extension tablefunc  ：digoal=# create extension tablefunc ;CREATE EXTENSIONnormal_rand： normal_rand(int numvals, float8 mean, float8 stddev) r

create type：http://www.postgresql.org/docs/9.3/static/sql-createtype.html enum:http://www.postgresql.org/docs/9.3/static/datatype-enum.html，http://www.postgresql.org/docs/9.3/static/functions-enum.htm

http://www.postgresql.org/docs/9.3/static/functions-aggregate.html array_agg： 聚合函数，返回一个array，相当于oracle的wm_concat：digoal=# select array_agg(fooid) from foo; array_agg ----------------- {4,5,7,6,1

setof： 返回多行结果集：digoal=# CREATE TYPE compfoo AS (f1 int, f2 text);CREATE TYPEdigoal=# CREATE FUNCTION textst() RETURNS SETOF compfoo AS $$digoal$# SELECT fooid, fooname FROM foodigoal$# $$ LANGUAGE

1：vacuum full会lock table ，vacuum不会。2：vacuum只是将deadtuple的行的空间转换为能够使用的状态，vacuum full会将这些空间碎片后面的数据上移。http://www.postgresql.org/docs/9.2/static/routine-vacuuming.html#AUTOVACUUMhttp://www.cnblogs.com/dadu

alter一个表的列的时候会出现rewrites表： 比如添加一个有默认值的新列会rewrites重写表（即先vacuum full此表）：http://my.oschina.net/Kenyon/blog/99757 ctid来查看有默认值的新列：digoal=# select ctid,* from foo; ctid | fooid | foosubi

http://www.postgresql.org/docs/9.3/static/functions-comparisons.html#AEN18448Row-wise Comparison： row的定义：http://www.postgresql.org/docs/9.3/static/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS row与

http://www.postgresql.org/docs/9.3/static/functions-admin.htmlGeneric File Access Functions： 普通文件的访问方法：digoal=# select pg_ls_dir('.'); pg_ls_dir ----------------- pg_multixact pg_notify postmast

继承： http://www.postgresql.org/docs/9.3/static/ddl-inherit.html分区表： http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html 分区表需要和trigger一起使用才可。CREATE TABLE measurement ( city_id int

Postgres-XC:http://blog.csdn.net/huguangshanse00/article/details/9636621http://blog.163.com/digoal@126/blog/static/1638770402013332335933/http://blog.163.com/digoal@126/blog/static/1638770402013310018