Devart Forums

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.

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

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.

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

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