i have a written a short postgres sql function.
this function can you find below:
CREATE FUNCTION "left"(text, integer) RETURNS text
LANGUAGE plpgsql
AS $_$
DECLARE
BEGIN
RETURN substr($1, 1, $2);
END;
$_$;
i used latest dotconnect for postgres
but unfortunately executing of pgsqlscript is not possible because of following error message:
Dollar-Quotes nicht abgeschlossen bei „$_$
DECLARE
BEGIN
RETURN substr($1, 1, $2)
in english:
dollar quotes not terminated !!!!
into program pgadmin i can run this function with out any problems.
Problem executing PgSqlScript for creating postgres sql function
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem executing PgSqlScript for creating postgres sql function
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem executing PgSqlScript for creating postgres sql function
We have fixed the bug with executing query in PgSqlScript containing function declarations. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Re: Problem executing PgSqlScript for creating postgres sql function
this sounds great.
i'am waiting for the new version.
many thanks for your support.
i'am waiting for the new version.
many thanks for your support.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Problem executing PgSqlScript for creating postgres sql function
New build of dotConnect for PostgreSQL 7.4.535 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32775
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32775