Re: Reason(s) not to use a stored procedure - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: Reason(s) not to use a stored procedure
Date
Msg-id 20080122143356.GH21676@a-kretschmer.de
Whole thread Raw
In response to Reason(s) not to use a stored procedure  ("Mag Gam" <magawake@gmail.com>)
List pgsql-novice
am  Tue, dem 22.01.2008, um  8:49:39 -0500 mailte Mag Gam folgendes:
> I was in an academic meeting where a professor was preaching the reasons why
> not to use a stored procedure. He advised to always use SQL instead of a
> procedural language. Can someone please shed some light on this?

Why not use procedural languages? He told more about the reasons?


With plain SQL you can't use control structures like loops, with
languages like plpgsql you can map your application logic into the
db-server. I can't see any reasons against such procedures. Maybe he
knows only old MySQL...

Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-novice by date:

Previous
From: "Mag Gam"
Date:
Subject: Reason(s) not to use a stored procedure
Next
From: Nick Nick
Date:
Subject: Re: Reason(s) not to use a stored procedure