1 CREATE OR REPLACE FUNCTION find_planet_id(_ruler text, _planet text, _race race) RETURNS integer
8 SELECT pid, race INTO p FROM planets WHERE ruler = _ruler AND planet = _planet;
10 IF _race <> p.race THEN
11 UPDATE planets SET race = _race WHERE pid = p.pid;
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 pid INTO id;
25 DROP FUNCTION IF EXISTS findplanetid(character varying, character varying, character varying);
27 CREATE OR REPLACE FUNCTION find_alliance_id(alli text) RETURNS integer
32 SELECT aid FROM INTO id alliances WHERE alliance = alli;
34 INSERT INTO alliances(alliance) VALUES($1)
35 RETURNING aid INTO id;
42 DROP FUNCTION IF EXISTS 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;