SRF and pg_group

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SRF and pg_group
Date: 2002-09-10 15:51:37
Message-ID: Pine.LNX.4.21.0209101636580.619-500000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I realise that this has already been done, by Joe Conway I think. Indeed I was
looking at this just before beta1 when I happened to notice the post giving the
plpgsql function. However, as I had started work on it and I was interested in
seeing how things should be done I continued, only not in so much of a rush.

In the interests on finding out if I have approached this the right way, or the
way a more experienced backend programmer would, I'd appreciate any comments on
the attached .c file. In particular, I'm not sure what I'm doing with regard to
memory contexts, I think I may have one unnecessary switch in there, and in
general I seem to be doing a lot of work just to find out tidbits of
information.

I based this on, i.e. started by editing, Joe Conway's tablefunc.c but I think
there's very little of the original left in there.

I've also attached the .h, Makefile and .sql.in files to make this work if
anyone is interested in giving it a run. The .sql.in shows the usage. I did
this in a directory called pggrouping, for the sake of a better name, under the
contrib directory in my tree, so that's probably the best place to build it.

Thanks, and sorry for adding to people's email and work load.

--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

Attachment Content-Type Size
pggrouping.c text/x-csrc 14.6 KB
pggrouping.h text/x-chdr 1.3 KB
Makefile text/plain 226 bytes
pggrouping.sql.in text/plain 642 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-09-10 15:57:34 Re: Optimization levels when compiling PostgreSQL...
Previous Message Sean Chittenden 2002-09-10 15:37:50 Re: Optimization levels when compiling PostgreSQL...