Rhys Stewart wrote:
hi all,
are there any function in pl/pgsql to call a shell script? or like is
there a pl/bash?
Actually scary enough, there is pl/bash. Google is your friend. You can
also use:
plpython, plperl, plphp, pljava etc...
Joshua D. Drake
Rhys
Peace & Love | Live Long & Pr
On Fri, May 12, 2006 at 09:54:23AM -0500, Rhys Stewart wrote:
> are there any function in pl/pgsql to call a shell script? or like is
> there a pl/bash?
PL/sh might be what you're after; you could also use PL/Perl, etc.
http://pgfoundry.org/projects/plsh/
What does the shell script do? Having t
On Friday 12 May 2006 10:54 am, "Rhys Stewart" <[EMAIL PROTECTED]> thus
communicated:
--> hi all,
--> are there any function in pl/pgsql to call a shell script? or like is
--> there a pl/bash?
-->
You can use Perl in "untrusted" mode as a backend function and accomplish
something like that.
---
Two options I have run across.
pl/sh
http://developer.postgresql.org/~petere/pgplsh/
ShellSQL
http://www.edlsystems.com/shellsql/
On Friday 12 May 2006 07:54 am, Rhys Stewart wrote:
> hi all,
> are there any function in pl/pgsql to call a shell script? or like is
> there a pl/bash?
>
> Rhys
>
> Pea
[EMAIL PROTECTED] wrote:
Hi All!
First of all, a great Thanks, your suggestions works fine.
I'll hope to enhance a little bit my understanding of SETOF return type.
I have now two problems.
1) I would like to return some columns from one table in PL/pgSQL function.
What's in this case the corr
ne
>A: Ycrux <[EMAIL PROTECTED]>
>Copie à: pgsql-general@postgresql.org
>Sujet: Re: [GENERAL] PL/pgSQL question
>Date: Thu, 09 Mar 2006 19:25:52 -0500
>De: Tom Lane <[EMAIL PROTECTED]>
>
>Ycrux <[EMAIL PROTECTED]> writes:
>> # SELECT grantAccess(
Ycrux <[EMAIL PROTECTED]> writes:
> # SELECT grantAccess('sara', 'sarapass');
> ERROR: set-valued function called in context that cannot accept a set
You need to do "SELECT * FROM grantAccess(...)". This is a plpgsql
implementation restriction that we'll probably try to fix someday,
although the
Mitch Vincent wrote:
>
> I haven't used PL/pgSQL very much but it looks like a good language in which
> to make some simple functions for this application I'm writing..
>
> Is it possible (with PL/pgSQL) to access other records in other tables than
> the tuple that pulled the trigger (and called
