From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Auto-timestamp generator (attached) |
Date: | 2001-02-08 14:03:45 |
Message-ID: | 981641025.3a82a741a3428@webmail.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Quoting Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>:
> I think that modules like this could be included in the distribution or
> archieved at the ftp. They'd make it easier for people new to sql to
> start using postgresql. Also there would be no performance loss in
> the backend code, as these "modules" don't need any support.
This is what /contrib in the source is for ;-)
Peter
>
> - Einar
>
> On Thu, 8 Feb 2001, Richard Huxton wrote:
> > Following the 'new type proposal' discussion recently I decided to
> have a
> > play at creating an automatic trigger generator. Attached is the sql
> and an
> > example of its use.
> >
> > Basically you call a function:
> > select lastchg_addto(mytable,mycol);
> > where mycol is of type timestamp. The function builds the
> >
> > To use it you will need plpgsql enabled (man createlang) and also
> version
> > 7.1
> > After use, there are two functions left - you can remove these with:
> > drop function lastchg_addto(text,text);
> > drop function lastchg_remove(text,text);
> >
> > I've tried to layout the plpgsql for ease of understanding - if you
> want to
> > see how the trigger gets created, you can return exec1 or exec2
> instead of
> > the success message.
> >
> > This just a demo - obviously it's fairly simple to put together
> triggers for
> > this purpose, but I'd appreciate any thoughts about the approach.
> >
> > TIA people
> >
> > Oh - 2 questions for any of the developers/clued up
> >
> > 1. Is there any way to parse a variable-length list of parameters in
> > plpgsql?
> > 2. Is there any chance of a different quoting method for functions?
> e.g.
> > create function ... as q[ ...body here ...];
> > So we can avoid the '''' stuff - it's a lot of static
> >
> > - Richard Huxton
> >
>
>
--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Murrain | 2001-02-08 14:46:12 | tuples too big |
Previous Message | Stefan Waidele jun. | 2001-02-08 13:52:23 | Re: numeric type and odbc from access 2000 |