set autoread syntax on "set number " filetype ident on "set autoindent "set expandtab set cindent set shiftwidth=4 autocmd FileType make setlocal noexpandtab set tabstop=4 set showmatch set matchtim... Read More
posted @ 2017-05-28 23:45 庚武 Views(291) Comments(0) Diggs(0) Edit
coalesce(expr1,expr2,expr3...) 直到找到一个非null值返回,右边的表达式则不参与运算;若所有为null,返回null. eg:判断json是否包含某属性,若无,则取默认值。 testdb=# select val * 2 from (select id, coales Read More
posted @ 2017-05-28 12:15 庚武 Views(8561) Comments(0) Diggs(0) Edit