Re: COnsidering a move away from Postgres - Mailing list pgsql-general

Jason Tesser <jtesser@nbbc.edu> writes:
> 1. Our dev plan involves alot of stored procedures to be used and we have
> found the way this is done in PG to be painful. (ie.  To return multiple
> record from different tables you have to define a type.

FWIW, this won't be essential any more in 8.1.  See the examples in the
development documentation:
http://developer.postgresql.org/docs/postgres/xfunc-sql.html#XFUNC-OUTPUT-PARAMETERS
http://developer.postgresql.org/docs/postgres/plpgsql-declarations.html#PLPGSQL-DECLARATION-ALIASES
http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING

> 2. Also with stored procs it is painful to return mulitple records. The syntax
> is more complicated than some other databases.  (We are currently using
> PL/SQL)

What's so hard about RETURN NEXT?  What would you rather have?

> 3. The tools.  PgAdmin does some things well but it is lacking the features of
> some of the other gui tools.

I'm sure the pgAdmin guys would love having some more help.

            regards, tom lane