「PostgreSQLパッチ」の編集履歴(バックアップ)一覧に戻る
- SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed + SELECT vars, ip, extract(epoch from changed) AS changed
create or replace function unix_timestamp (timestamp with time zone) time zoneがある場合 returns int as ' declare date alias for $1; timezero timestamp; offset interval; begin timezero := timestamp ''1970-1-1 00:00'' at time zone ''utc''; offset := date-timezero; return ( extract(''days'' from offset)*86400+ extract(''hours'' from offset)*3600+ extract(''minutes'' from offset)*60+ extract(''seconds'' from offset))::int; end; ' language 'plpgsql';
- SELECT identity_id, name, email FROM identities WHERE user_id=1 AND del!='1' ORDER BY "default" DESC, name ASC + SELECT identity_id, name, email FROM identities WHERE user_id=1 AND del!='1' ORDER BY \"default\" DESC, name ASC
program\steps\mail\compose.inc(94): ORDER BY `default` DESC, name ASC", program\steps\settings\func.inc(151): ORDER BY `default` DESC, name ASC",
@@ -169,7 +169,7 @@ - $result =& $this->db_handle->getOne("SELECT CURRVAL('" .$sequence. "')"); + $result =& $this->db_handle->getOne("SELECT CURRVAL('$sequence')");