Thread: Stored Procedures Basics

Hello All,

I tried to search for information on Stored Procedures but couldn't find
anything specific on stored procedures. My aim is to show the difference
between stored procedures and triggers.

any kind of help appriciated.

Cheers
Prasad.

am  10.10.2005, um 12:10:27 +0000 mailte Prasad dev folgendes:
>
> Hello All,
>
> I tried to search for information on Stored Procedures but couldn't find
> anything specific on stored procedures. My aim is to show the difference
> between stored procedures and triggers.

A trigger is only fired up on INSERT/UPDATE/DELETE. A stored proc can
you call every time via SELECT.


Mit freundlichen Grüßen, A. Kretschmer
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Prasad,

Look in the documentation for User Defined Functions.

HTH,

Kevin




-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Prasad dev
Sent: Monday, October 10, 2005 8:10 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Stored Procedures Basics


Hello All,

I tried to search for information on Stored Procedures but couldn't find
anything specific on stored procedures. My aim is to show the difference
between stored procedures and triggers.

any kind of help appriciated.

Cheers
Prasad.



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings