diff options
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql')
-rwxr-xr-x | mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/GHTDBEX.PostgreSQL.sql | 13 |
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 |