Writing most code in Stored Procedures

From: Rohit <rpk(dot)general(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Writing most code in Stored Procedures
Date: 2007-08-15 12:17:49
Message-ID: 1187180269.668086.65270@q3g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have few queries regarding the use of Stored Procedures, Functions
and Triggers in an RDBMS.

(1) When to use Stored Procedure? Writing an INSERT query in a Stored
Procedure is better or firing it from the application level?

(2) Can a Trigger call a Stored Procedure?

(3) What type of code must reside in application and what type in
RDBMS?

(4) Is it faster to work at application level or at the database level?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2007-08-15 12:30:30 Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
Previous Message Martijn van Oosterhout 2007-08-15 12:04:36 Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"