You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@trafodion.apache.org by Radu Marias <ra...@gmail.com> on 2015/09/12 11:18:09 UTC

Does Trafodion support stored procedures/functions similar to the ones in Posgresql PL/pgSQL?

Hi,

In the SQL Reference Manual I noticed there are only User Defined Functions
in C (UDFs) and Stored Procedures in Java (SPJ). Does it also have
something like
http://www.postgresql.org/docs/9.4/static/plpgsql-structure.html ?

-- 
And in the end, it's not the years in your life that count. It's the life
in your years.

Re: Does Trafodion support stored procedures/functions similar to the ones in Posgresql PL/pgSQL?

Posted by Radu Marias <ra...@gmail.com>.

We have some PL/SQL functions that we would need to migrate to trafodion,
so I think the best option is to rewrite them in SPJ right?

On Sat, Sep 12, 2015, 23:36 Suresh Subbiah <su...@gmail.com>
wrote:

> Hi Radu,
>
> Sorry, no. Trafodion does not have this. The closest in Traf to PL/SQL is
> SPJ.
> If you outline the use you have in mind we could discuss what the best
> option would be.
>
> Thanks
> Suresh
>
>
> On Sat, Sep 12, 2015 at 4:18 AM, Radu Marias <ra...@gmail.com> wrote:
>
> > Hi,
> >
> > In the SQL Reference Manual I noticed there are only User Defined
> Functions
> > in C (UDFs) and Stored Procedures in Java (SPJ). Does it also have
> > something like
> > http://www.postgresql.org/docs/9.4/static/plpgsql-structure.html ?
> >
> > --
> > And in the end, it's not the years in your life that count. It's the life
> > in your years.
> >
>

Re: Does Trafodion support stored procedures/functions similar to the ones in Posgresql PL/pgSQL?

Posted by Suresh Subbiah <su...@gmail.com>.

Hi Radu,

Sorry, no. Trafodion does not have this. The closest in Traf to PL/SQL is
SPJ.
If you outline the use you have in mind we could discuss what the best
option would be.

Thanks
Suresh

On Sat, Sep 12, 2015 at 4:18 AM, Radu Marias <ra...@gmail.com> wrote:

> Hi,
>
> In the SQL Reference Manual I noticed there are only User Defined Functions
> in C (UDFs) and Stored Procedures in Java (SPJ). Does it also have
> something like
> http://www.postgresql.org/docs/9.4/static/plpgsql-structure.html ?
>
> --
> And in the end, it's not the years in your life that count. It's the life
> in your years.
>