diff options
author | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
commit | fc2b26a6a27d19ecbfbb2202fd35b37568c65181 (patch) | |
tree | f9123f21920265535bfab4987d8aac674bbbbe08 /schema/versions | |
parent | f8232151a0a4bdd430e928d742686a2330e99d68 (diff) |
add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201)
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/35.sql | 1 | ||||
-rw-r--r-- | schema/versions/pgsql/35.sql | 3 |
2 files changed, 4 insertions, 0 deletions
diff --git a/schema/versions/mysql/35.sql b/schema/versions/mysql/35.sql new file mode 100644 index 000000000..ad112a021 --- /dev/null +++ b/schema/versions/mysql/35.sql @@ -0,0 +1 @@ +update ttrss_version set schema_version = 35; diff --git a/schema/versions/pgsql/35.sql b/schema/versions/pgsql/35.sql new file mode 100644 index 000000000..e624d66b3 --- /dev/null +++ b/schema/versions/pgsql/35.sql @@ -0,0 +1,3 @@ +create function SUBSTRING_FOR_DATE(timestamp, int, int) RETURNS text AS 'SELECT SUBSTRING(CAST($1 AS text), $2, $3)' LANGUAGE 'sql'; + +update ttrss_version set schema_version = 35; |