diff options
author | Pacien TRAN-GIRARD | 2015-01-27 18:01:45 +0100 |
---|---|---|
committer | Pacien TRAN-GIRARD | 2015-01-27 18:27:51 +0100 |
commit | afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf (patch) | |
tree | e6808c16b8bf7b7a2cd79435706465181cbe4295 /res/sql/functions/pg_gen_uuid.sql | |
parent | 999d0ebce6b2f4ba39ee55daa52ca33f5fac657c (diff) | |
download | minibay-afe377a9b10b5c1b2badc74d4b9b636e7c4d0cbf.tar.gz |
Add E-R model and SQL bootstrap scripts
Diffstat (limited to 'res/sql/functions/pg_gen_uuid.sql')
-rw-r--r-- | res/sql/functions/pg_gen_uuid.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/res/sql/functions/pg_gen_uuid.sql b/res/sql/functions/pg_gen_uuid.sql new file mode 100644 index 0000000..c592385 --- /dev/null +++ b/res/sql/functions/pg_gen_uuid.sql | |||
@@ -0,0 +1,9 @@ | |||
1 | CREATE OR REPLACE FUNCTION gen_uuid() | ||
2 | RETURNS VARCHAR | ||
3 | AS ' | ||
4 | BEGIN | ||
5 | |||
6 | RETURN upper(cast(uuid_generate_v4() AS VARCHAR)); | ||
7 | |||
8 | END; | ||
9 | ' LANGUAGE plpgsql; | ||