Vic Cekvenich wrote:
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.
Start from "Chapter 19. PL/pgSQL - SQL Procedural Language" on Postgresql documentation. I think, you can find there everything you need for pl/pgsql. After you read this, search techdocs.postgresql.org site. Lots of examples could be find on braseiro.net (don't remember spelling)
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.
|| has nothing to pl/pgsql. It is a part of SQL standard - string concatenation.
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).
Use "RAISE NOTICE ''My name is: %'',some_row.name " and "RAISE EXCEPTION ..." Regards, Tomasz Myrta ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
