Problem executing PgSqlScript for creating postgres sql function

[juju]

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.

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[Pinturiccio]

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.

[juju]

this sounds great.
i'am waiting for the new version.
many thanks for your support.

[Pinturiccio]

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