From fc2b26a6a27d19ecbfbb2202fd35b37568c65181 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Mon, 21 Apr 2008 05:53:19 +0100
Subject: add workaround for psql 8.3 stricter typechecking on SUBSTRING()
 (refs #201)

---
 schema/versions/mysql/35.sql | 1 +
 schema/versions/pgsql/35.sql | 3 +++
 2 files changed, 4 insertions(+)
 create mode 100644 schema/versions/mysql/35.sql
 create mode 100644 schema/versions/pgsql/35.sql

(limited to 'schema/versions')

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;
-- 
cgit v1.2.3