From: Tomasz Myrta <jasiek@klaster.net>
To: Vic Cekvenich <vc@basebeans.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: help: pgSQL docs and debug
Date: Sun, 02 Feb 2003 18:34:26 +0100
Message-ID: <3E3D56A2.3010000@klaster.net> (raw)
References: <3E3D2F9E.2040909@basebeans.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasiek@klaster.net, vc@basebeans.com
Subject: Re: help: pgSQL docs and debug
In-Reply-To: <3E3D56A2.3010000@klaster.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox