[GENERAL] Tool to ease development of plpgsql

[bill.postgresql-users]

What's the best way to ease development of plpgsql.

My largest issues with plpgsql pertain to the quoting of course.

Bill McMilleon


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] 7.4 -> 7.4.1 upgrade with customization on freebsd

[bill.postgresql-users]

I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE).
Did nothing special, just make && make install and all was well.

I now have updated my ports collection via cvsup and see that the 7.4.1 port
is available.  So now I have several, very specific needs:

1) having now done some development in 7.4, I've decided I need to be able
to exceed the default limit of 16 arguments for plpgsql functions

2) I would like to upgrade to 7.4.1 without having to re-edit any config
files or change any paths.

3) I would like to prevent the database shown by "pkg_version -v" from
having one entry for 7.4 and another for 7.4.1

Suggestions?  Caveat: I'm a java + sql centered coder and makefiles make me
wince.


Bill McMilleon


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] Support for functions returning mutliple result sets?

[bill.postgresql-users]

I know I can write plpgsql functions that return sets.
Does postgres support returning multiple sets from a function?

Bill McMilleon 


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly