Adding Functionality

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
>From pgsql-general-owner(at)postgresql(dot)org Wed Feb 18 12:59:08 2004
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [200.46.204.2])
by svr1.postgresql.org (Postfix) with ESMTP id 797BBD1B456
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 18 Feb 2004 16:58:57 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
with ESMTP id 01167-01
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 18 Feb 2004 12:58:51 -0400 (AST)
Received: from gw.tssi.com (gw.tssi.com [198.147.197.1])
by svr1.postgresql.org (Postfix) with ESMTP id A0E69D1E0D2
for <pgsql-general(at)postgresql(dot)org>; Wed, 18 Feb 2004 12:58:50 -0400 (AST)
Received: from gw.tssi.com (nolan(at)gw(dot)tssi(dot)com [127.0.0.1] (may be forged))
by gw.tssi.com (8.12.6/8.12.6) with ESMTP id i1IGwk8S013950;
Wed, 18 Feb 2004 10:58:47 -0600
Received: (from nolan(at)localhost)
by gw.tssi.com (8.12.6/8.12.6/Submit) id i1IGwk2w013948;
Wed, 18 Feb 2004 10:58:46 -0600
From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Message-Id: <200402181658(dot)i1IGwk2w013948(at)gw(dot)tssi(dot)com>
Subject: Re: Differences between postgres and mysql
To: tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
Date: Wed, 18 Feb 2004 10:58:45 -0600 (CST)
Cc: mark(dot)cubitt(at)applegate(dot)co(dot)uk, pgsql-general(at)postgresql(dot)org
In-Reply-To: <24159(dot)1077122316(at)sss(dot)pgh(dot)pa(dot)us> from "Tom Lane" at Feb 18, 2004 11:38:36 AM
X-Mailer: ELM [version 2.5 PL3]
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/843
X-Sequence-Number: 57554

> Interesting you should say that, because for years we were getting beat
> up regularly about how poor our ALTER capabilities were compared to
> MySQL's. Have we really passed them up in ALTER flexibility? Or is
> there some other limitation you are thinking of?

I wasn't commenting on the flexibility issue, more on performance.

If you add or delete a column doesn't MySQL copy the table to a temp
table then delete the original one and rename the copy?

Try doing that on a table with 25 million rows and you can go to dinner
and a movie while you wait for it to finish. Try it on a really big
table and you can go to a performance of the Ring Cycle while you're
waiting. (And I mean the Wagner Ring, not Tolkien.)

I didn't comment on the interactive user interfaces. While there are a
few things about psql that drive me nuts (like the fact that it always does
the edit to a temporary file so it goes away immediately upon exit and
some of the ways \o works, I'm used to using both features in Oracle
to provide a historical trail of my work), mysql can't even repeat a
command (\g) without first re-editing it.
--
Mike Nolan