1 CREATE OR REPLACE FUNCTION find_planet_id(_ruler text, _planet text, _race race) RETURNS integer
8 SELECT id, race INTO p FROM planets WHERE ruler = _ruler AND planet = _planet;
10 IF _race <> p.race THEN
11 UPDATE planets SET race = _race WHERE id = p.id;
15 INSERT INTO forum_threads (fbid,subject,uid) VALUES(-2, _ruler || ' OF ' || _planet, -3)
16 RETURNING ftid INTO thread;
17 INSERT INTO planets(ruler,planet,race,ftid) VALUES(_ruler,_planet,_race,thread)
18 RETURNING id INTO pid;
25 DROP FUNCTION findplanetid(character varying, character varying, character varying);
27 CREATE OR REPLACE FUNCTION find_alliance_id(alliance text) RETURNS integer
32 SELECT id FROM INTO aid alliances WHERE name = alliance;
34 INSERT INTO alliances(name) VALUES($1)
35 RETURNING id INTO aid;
42 DROP FUNCTION find_alliance_id(character varying);
44 CREATE OR REPLACE FUNCTION coords(x integer, y integer, z integer) RETURNS text
46 SELECT $1 || ':' || $2 || ':' || $3
48 LANGUAGE sql IMMUTABLE;