Thread: User Defined Functions

Hi there,

Can anybody tell me about User Defined Functions in Postgresql? For what
I know, UDF's and in a very early state of development, am I right?

Where can I find documentation on this? What else should I know on this
matter?

Thanks!
- Ricardo

kbase <kb@e-virgula.com> writes:
> Can anybody tell me about User Defined Functions in Postgresql? For what
> I know, UDF's and in a very early state of development, am I right?

No, UDFs in PostgreSQL are a mature feature, and have been included
for as long as I've been using the product for, at any rate.

Docs:

http://developer.postgresql.org/docs/postgres/index.html
http://developer.postgresql.org/docs/postgres/xfunc.html

As well as chapters in most of the books on PostgreSQL.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

Thanks, this answers some of my questions
I found out that you can even write your UDF's in Perl, which are great
news (http://www.devx.com/dbzone/articles/renaker03/renaker03-1.asp)

However, I haven't found any reference to writing UDF's in Java. I
suppose it's possible. Am I wrong? How is UDF writing in other languages
than C/C++/SQL supported?

thanks!
- Ricardo

On Sat, 2002-09-21 at 02:45, Neil Conway wrote:
> kbase <kb@e-virgula.com> writes:
> > Can anybody tell me about User Defined Functions in Postgresql? For what
> > I know, UDF's and in a very early state of development, am I right?
>
> No, UDFs in PostgreSQL are a mature feature, and have been included
> for as long as I've been using the product for, at any rate.
>
> Docs:
>
> http://developer.postgresql.org/docs/postgres/index.html
> http://developer.postgresql.org/docs/postgres/xfunc.html
>
> As well as chapters in most of the books on PostgreSQL.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>

kbase <kb@e-virgula.com> writes:
> However, I haven't found any reference to writing UDF's in Java.

http://pljava.sourceforge.net/

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC