Re: Adding Functionality

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Fernando Alonso Renault <proyectolsd(at)wanadoo(dot)es>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Adding Functionality
Date: 2004-02-18 17:27:40
Message-ID: 20040218172740.GA21339@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

That stuff defines the pg_proc table. Generally you use the CREATE FUNCTION
command to add functions. It takes care of all these details for you :)

\d pg_proc might give you some info.

On Wed, Feb 18, 2004 at 11:49:39AM -0500, Fernando Alonso Renault wrote:
> Hello,
>
> i'm quite a newbie using postgres 7.2 so this may be an easy question, but how do i add new funtionality? I mean, i wanna add a couple of new functions, and i've found this files, pg_proc.h and fmgrtab.c, but i don't know the meaning of the fields, so i can't add anything.
>
> For instance, in fmgrtab.c:
>
> { 61, "chareq", 2, true, false, chareq }
>
> i know 61 is like the port or id for the function, "chareq" and chareq the name, but what about the 2, the true and the false? could be that 2 is the number of arguments?
>
> And in pg_proc.h
>
> DATA(insert OID = 61 ( chareq PGUID 12 f t t t 2 f 16 "18 18" 100 0 0 100 chareq - ))
>
> what's the meaning of those f's?
>
> Thank you very much!
>
> http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
> http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-02-18 17:35:54 Re: PostgreSQL Indexing versus MySQL
Previous Message Randall Skelton 2004-02-18 16:58:24 Join with equals?