* SELECT [#tec1d5ba]
** CASE [#u88dbb64]
SELECT CASE WHEN status = 1 THEN '表示' ELSE '非表示' END AS _status FROM user;
** COALESCE [#v97c0975]
SELECT COALESCE(email1, email2, 'NO EMAIL') FROM user;
NULLでない最初の引数を返す。全てNULLの場合はNULLを返す。
http://www.postgresql.jp/document/pg833doc/html/functions-conditional.html#AEN14490
** タイムスタンプを文字列に変換 [#n1a781f3]
SELECT to_char(now(), 'YYYY/MM/DD HH24:MI::SS');
http://www.postgresql.jp/document/pg833doc/html/functions-formatting.html
** ランダムに取得 [#x2b3a4d0]
SELECT id FROM user ORDER BY random()
