有一张桌子可容纳所有游戏(每个游戏由3名玩家扮演)：

# select * from pref_games where gid=321;
 gid | rounds |          finished
-----+--------+----------------------------
 321 |     17 | 2011-10-26 17:16:04.074402
(1 row)

并且有一张桌子可以控制该游戏的玩家分数#321：

# select * from pref_scores where gid=321;
      id       | gid | money | quit
----------------+-----+-------+------
 OK531282114947 | 321 |   218 | f
 OK501857527071 | 321 |  -156 | f
 OK429671947957 | 321 |   -62 | f

当我在Postgresql的psql-prompt上尝试以下SELECT INTO语句时,它似乎按预期工作(当会话关闭时临时表消失)：

# select gid into temp temp_gids from pref_scores where id='OK446163742289';
SELECT
 
# select * from temp_gids ;
 gid
------
 1895
 1946
 1998
 2094
 2177
 2215
(6 rows)

但是当我尝试创建我的PL / pgsql过程时,我收到错误：

create or replace function pref_delete_user(_id varchar)
        returns void as $BODY$
            begin
 
            select gid into temp temp_gids from pref_scores where id=_id;
            delete from pref_scores where gid in
                (select gid from temp_gids);
            delete from pref_games where gid in
                (select gid from temp_gids);
 
            delete from pref_rep where author=_id;
            delete from pref_rep where id=_id;
 
            delete from pref_catch where id=_id;
            delete from pref_game where id=_id;
            delete from pref_hand where id=_id;
            delete from pref_luck where id=_id;
            delete from pref_match where id=_id;
            delete from pref_misere where id=_id;
            delete from pref_money where id=_id;
            delete from pref_pass where id=_id;
            delete from pref_status where id=_id;
            delete from pref_users where id=_id;
 
            end;
    $BODY$language plpgsql;

错误：

ERROR:  Syntax error at "temp"
DETAIL:  Expected record variable,row variable,or list of scalar variables following INTO.
CONTEXT:  compilation of PL/pgsql function "pref_delete_user" near line 3

为什么(临时表不允许在这里？)以及保存我要删除的gid临时列表的位置？

(而且我不想使用“删除级联”,因为我还没有习惯它,我的脚本/数据库还没有准备好).