pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

help: pgSQL docs and debug
2+ messages / 2 participants
[nested] [flat]

* help: pgSQL docs and debug
@ 2003-02-02 14:47 Vic Cekvenich <vc@basebeans.com>
  2003-02-02 17:34 ` Re: help: pgSQL docs and debug Tomasz Myrta <jasiek@klaster.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Vic Cekvenich @ 2003-02-02 14:47 UTC (permalink / raw)
  To: pgsql-sql

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: help: pgSQL docs and debug
  2003-02-02 14:47 help: pgSQL docs and debug Vic Cekvenich <vc@basebeans.com>
@ 2003-02-02 17:34 ` Tomasz Myrta <jasiek@klaster.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Tomasz Myrta @ 2003-02-02 17:34 UTC (permalink / raw)
  To: Vic Cekvenich <vc@basebeans.com>; +Cc: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-02-02 17:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-02 14:47 help: pgSQL docs and debug Vic Cekvenich <vc@basebeans.com>
2003-02-02 17:34 ` Tomasz Myrta <jasiek@klaster.net>

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