#368 Stored Procedures with Postgres

[Anonymous]

It is apparently not not possible to execute stored procedures for postgresql.
If I take a very basic example:
create function populateFact() returns int as $$
begin
return 42;
end
$$ language plpgsql;

I got an error:
Error: ERROR: unterminated dollar-quoted string at or near "$$
begin
return 42"
Position: 47
SQLState: 42601
ErrorCode: 0
Error occured in:
create function populateFact() returns int as $$
begin
return 42

It would be nice to extend the postgres plug in to support this.

Postgresql 8.4
Java 6
Squirrel 3.0.2

[Andy Schönemann]

instead of $$, use '