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

Re: adding operators

From: "Islam Hegazy" <islheg(at)gmail(dot)com>
To: "Brendan Jurd" <direvus(at)gmail(dot)com>,<darcy(at)druid(dot)net>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: adding operators
Date: 2007-10-01 17:17:47
Message-ID: 010301c80450$cdbe6180$ (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Thanks for this information. It was really helpful.

Another problem that is facing me is altering existing functions. For 
example, what if I want to change the execution of the SUM function to work 
as follows:

select sum(a)
from mytable w(5);

which means to sum only 5 records or records that arrived in the last 5 
minutes. Do I need to change the core code of PostgreSQL to implement such 

Islam Hegazy

----- Original Message ----- 
From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: "Islam Hegazy" <islheg(at)gmail(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Sunday, September 30, 2007 8:38 PM
Subject: Re: [HACKERS] adding operators

> 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.
> Regards,
> BJ 

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2007-10-01 17:22:33
Subject: Re: Enforcing database encoding and locale match
Previous:From: Gregory StarkDate: 2007-10-01 17:15:08
Subject: Re: First steps with 8.3 and autovacuum launcher

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