Who dreads PL/pgSQL? It's a pretty easy language to learn. Granted, not
as easy as one you already know, but I'm not aware of any RDBMS that
supports C# as a stored procedure language.
I needd to re-write a lot of compliatated SQL select statements to run them
in server which generate reports.
Currently they are running in client side.
Client application uses procedural language to do additional processing of
data retrieved from PostgreSQL server.
I need to create new client application. So I desided that I must move as
much processing to server as possible.
Using C# should make my procedures portable to MS SQL, DB2 also.
I'm looking for things available in modern language IDEs like
auto-completion, intellisence, immediate syntax check
and modern language features like classes, generic, interfaces.
There a much more source code, resources and books available in C# than in
pl/pgSQL.
C# allows to use whole .NET class library, which contains solutions for
almost everything.
I think that using pgAdmin+PL/pgSQL decreases my productivity a lot compared
to Visual Studio + C#
Andrus.
