Skip site navigation (1) Skip section navigation (2)

Re: Reason(s) not to use a stored procedure

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Reason(s) not to use a stored procedure
Date: 2008-01-22 14:33:56
Message-ID: 20080122143356.GH21676@a-kretschmer.de (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-novice by date

Next:From: Nick NickDate: 2008-01-22 15:23:41
Subject: Re: Reason(s) not to use a stored procedure
Previous:From: Mag GamDate: 2008-01-22 13:49:39
Subject: Reason(s) not to use a stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group