Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/mono/mono.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql')
-rwxr-xr-xmcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql b/mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql
new file mode 100755
index 00000000000..64ec295a4d1
--- /dev/null
+++ b/mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql
@@ -0,0 +1,13 @@
+DROP FUNCTION GH_DUMMY(CHAR);
+
+
+CREATE FUNCTION GH_DUMMY(CHAR) RETURNS refcursor AS $$
+DECLARE
+ rct1 refcursor;
+
+BEGIN
+ OPEN rct1 FOR
+ SELECT * FROM Customers where CustomerID = $1;
+ RETURN rct1;
+END;
+$$ LANGUAGE 'plpgsql'; \ No newline at end of file