テストデータ http://mono-space.net/jpug_study.txt 以下はエラー select south.t, min(east.t) , min(east.t) - south.t from east,south where (east.t > (south.t + time '00:10')) group by south.t ; ERROR: operator is not unique: time without tim…

sqlだと 以下で通る文が select count(*) from pg_class where relkind = 'r'; plpgsqlだと CREATE OR replace FUNCTION myfunc3() RETURNS integer AS ' DECLARE arg1 integer; BEGIN select count(*) into arg1 from pg_class where relkind = "r" RETURN …

CREATE FUNCTION hello() RETURNS text AS ' BEGIN RETURN ''Helo, World''; END 'LANGUAGE 'plpgsql'; RETURN arg1 + arg2; CREATE OR REPLACE FUNCTION myfunc2(int4, int4) RETURNS int4 AS $BODY$ DECLARE arg1 alias FOR $1; arg2 alias FOR $2; BEGIN …

[サーバー]-[PostgreSQL Database Server 8.1] [データベース][プロパティ]-[新しいデータベース]