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