summaryrefslogtreecommitdiffstats
path: root/sql/group_insert.sql
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:08:06 +0100
committerAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:08:06 +0100
commit3d772413a194c5b33d4202285d46b285920c475b (patch)
treeb28802aa22cc489fe26019ebe58af7c3e38561a6 /sql/group_insert.sql
parent39081f84a402aebb52d98a43e4675c90135cea9b (diff)
downloadts3db_postgres-3d772413a194c5b33d4202285d46b285920c475b.tar.gz
ts3db_postgres-3d772413a194c5b33d4202285d46b285920c475b.tar.xz
ts3db_postgres-3d772413a194c5b33d4202285d46b285920c475b.zip
modified sql statements to work with postgresql
Diffstat (limited to '')
-rw-r--r--sql/group_insert.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/group_insert.sql b/sql/group_insert.sql
index 0989111..bbc79a9 100644
--- a/sql/group_insert.sql
+++ b/sql/group_insert.sql
@@ -1 +1 @@
-insert into :table: (server_id, name, type) values (:server_id:, :name:, :type:)
+insert into :table: (server_id, name, type) values (:server_id:, :name:, :type:) returning group_id as last_inserted_id