X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5A192475CE7
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 09:48:47 -0500 (EST)
Received: from mail.mailsnare.net (mail.mailsnare.net [207.44.136.42])
	by postgresql.org (Postfix) with ESMTP id 2C74F4760FA
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 09:47:57 -0500 (EST)
Received: from 127.0.0.1 (localhost [127.0.0.1])
	by dummy.domain.name (Postfix) with SMTP id 47E054640D0
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 14:48:01 +0000 (UTC)
Received: from basebeans.com (pcp01379980pcs.levtwn01.pa.comcast.net
	[68.81.92.207])
	by mail.mailsnare.net (Postfix) with ESMTP id DFB584640CB
	for <pgsql-sql@postgresql.org>; Sun,  2 Feb 2003 14:48:00 +0000 (UTC)
Message-ID: <3E3D2F9E.2040909@basebeans.com>
Date: Sun, 02 Feb 2003 09:47:58 -0500
From: Vic Cekvenich <vc@basebeans.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.0.2) Gecko/20021120 Netscape/7.01
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: help: pgSQL docs and debug
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/32
X-Sequence-Number: 11430

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