[SQL] help: pgSQL docs and debug

[Vic Cekvenich]

I need to write some longer pgSQL stored procedures.

Can you help?
1. I am looking for a reference of pgSQL functions, etc.?
(I have all the books, they have just a few, I also looked all over the web).
If you can post a link, tia.

For example, what does the || do in pg SQL with a string?
I am looking at code examples and having a hard time to follow.


2. How do I debug pgSQL stored procedure?
Right now I write step by step.
Is there a "system.out" in pgSQL? Where does it show?
Is there a GUI editor that helps (I use pgADMIN II).

Any help appreciated.

.V




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org