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 |
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... |