From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | Markus Schaber <schabi(at)logix-tt(dot)com> |
Cc: | Daniel Caune <daniel(dot)caune(at)ubisoft(dot)com>, Owen Jacobson <ojacobson(at)osl(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Does PostgreSQL support job? |
Date: | 2006-02-02 16:33:40 |
Message-ID: | Pine.LNX.4.44.0602021832550.8152-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleus Mantzios | 2006-02-02 16:49:06 | Re: Does PostgreSQL support job? |
Previous Message | Markus Schaber | 2006-02-02 15:38:54 | Re: Does PostgreSQL support job? |