diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Session.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/sql/modules/Session.sql b/sql/modules/Session.sql index f8f0500e..4adf20d8 100644 --- a/sql/modules/Session.sql +++ b/sql/modules/Session.sql @@ -5,7 +5,12 @@ BEGIN SELECT * FROM open_forms WHERE session_id = in_session_id AND id = in_form_id; - IF FOUND THEN RETURN TRUE; + IF FOUND THEN + DELETE FROM open_forms + WHERE session_id = in_session_id AND id = in_form_id; + + RETURN TRUE; + ELSE RETURN FALSE; END; $$ language plpgsql; |