Skip site navigation (1) Skip section navigation (2)

Re: adding operators

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: "Brendan Jurd" <direvus(at)gmail(dot)com>
Cc: "Islam Hegazy" <islheg(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: adding operators
Date: 2007-10-01 06:53:57
Message-ID: 20071001025357.aacc36c1.darcy@druid.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 1 Oct 2007 12:38:07 +1000
"Brendan Jurd" <direvus(at)gmail(dot)com> wrote:
> On 10/1/07, Islam Hegazy <islheg(at)gmail(dot)com> wrote:
> > I am a graduate student in the University of Calgary. I want to add some new
> > operators to PostgreSQL to perform some specific tasks in a project I am
> > working in. My problem is that I cannot find my way into the code, where
> > should I start and where to find the documentation for the code.
> 
> There's no need to hack Postgres to add operators.  You can do so by
> defining functions using CREATE FUNCTION, and then hooking operators
> up to them using CREATE OPERATOR.

And if you need to add C code you can do that too.  Check some examples
in contrib such as my chkpass module for examples.

-- 
D'Arcy J.M. Cain <darcy(at)druid(dot)net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

In response to

pgsql-hackers by date

Next:From: Anoo Sivadasan PillaiDate: 2007-10-01 08:24:35
Subject: ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window
Previous:From: Andrew DunstanDate: 2007-10-01 03:51:11
Subject: Re: Latest ecpg patch broke MSVC build

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group