From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Markus Schaber <schabi@logix-tt.com>
Cc: Daniel Caune <daniel.caune@ubisoft.com>
Cc: Owen Jacobson <ojacobson@osl.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Does PostgreSQL support job?
Date: Thu, 2 Feb 2006 18:33:40 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0602021832550.8152-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <43E2144D.4030901@logix-tt.com>
O Markus Schaber Ýãñáøå óôéò Feb 2, 2006 :
> Hi, Daniel,
>
> Daniel Caune wrote:
>
> > I'm not sure to understand. Why calling a function from a script is different from executing a series of SQL commands? I mean, I can run a script defined as follows:
> >
> > SELECT myjob();
> >
> > where myjob is a stored procedure such as:
> >
> > CREATE OR REPLACE FUNCTION myjob()
> > RETURNS void
> > AS $$
> > <a-lot-of-complex-stuff-here>
> > END;
> > $$ LANGUAGE PLPGSQL;
> >
> > Does that make sense?
>
> It does make sense if myjob() does more than just execute a bunch of
> statements, e. G. it contains if(), loops or something else.
>
> PLPGSQL is turing complete, plain SQL is not.
Hmmmm is SQL equally powerful as a pushdown automaton then???
Just kidding!
>
> Markus
>
--
-Achilleus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, schabi@logix-tt.com, daniel.caune@ubisoft.com, ojacobson@osl.com
Subject: Re: Does PostgreSQL support job?
In-Reply-To: <Pine.LNX.4.44.0602021832550.8152-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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