Re: [HACKERS] Shortcut for defining triggers

2005-01-25 Thread David Fetter
On Tue, Jan 25, 2005 at 03:49:45PM -0600, Jim C. Nasby wrote: > On Mon, Jan 24, 2005 at 10:50:13AM +0200, Hannu Krosing wrote: > > ?hel kenal p?eval (p?hap?ev, 23. jaanuar 2005, 15:49-0600), kirjutas Jim > > C. Nasby: > > > Sorry if this is old, but I couldn't find it in the archives... > > > > >

Re: [HACKERS] Shortcut for defining triggers

2005-01-25 Thread Jim C. Nasby
On Mon, Jan 24, 2005 at 07:49:54PM -0800, David Fetter wrote: > > > Here's a sketch of what such an API might look like: > > > > > > CREATE TRIGGER foo_trg > > > BEFORE INSERT OR UPDATE ON foo_tab > > > FOR EACH ROW EXECUTE PROCEDURE > ^ > Maybe this sh

Re: [HACKERS] Shortcut for defining triggers

2005-01-25 Thread Jim C. Nasby
On Mon, Jan 24, 2005 at 10:50:13AM +0200, Hannu Krosing wrote: > ?hel kenal p?eval (p?hap?ev, 23. jaanuar 2005, 15:49-0600), kirjutas Jim > C. Nasby: > > Sorry if this is old, but I couldn't find it in the archives... > > > > How difficult would it be to provide a means to define a trigger in one

Re: [HACKERS] Shortcut for defining triggers

2005-01-25 Thread Hannu Krosing
Ühel kenal päeval (pühapäev, 23. jaanuar 2005, 15:49-0600), kirjutas Jim C. Nasby: > Sorry if this is old, but I couldn't find it in the archives... > > How difficult would it be to provide a means to define a trigger in one > statement? Something like a combination of CREATE TRIGGER and CREATE >

Re: [HACKERS] Shortcut for defining triggers

2005-01-24 Thread David Fetter
On Mon, Jan 24, 2005 at 08:40:30PM -0600, Jim C. Nasby wrote: > On Mon, Jan 24, 2005 at 08:12:49AM -0800, David Fetter wrote: > > On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote: > > > Sorry if this is old, but I couldn't find it in the archives... > > > > > > How difficult would it b

Re: [HACKERS] Shortcut for defining triggers

2005-01-24 Thread Jim C. Nasby
On Mon, Jan 24, 2005 at 08:12:49AM -0800, David Fetter wrote: > On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote: > > Sorry if this is old, but I couldn't find it in the archives... > > > > How difficult would it be to provide a means to define a trigger in > > one statement? Something

Re: [HACKERS] Shortcut for defining triggers

2005-01-24 Thread David Fetter
On Sun, Jan 23, 2005 at 03:49:22PM -0600, Jim C. Nasby wrote: > Sorry if this is old, but I couldn't find it in the archives... > > How difficult would it be to provide a means to define a trigger in > one statement? Something like a combination of CREATE TRIGGER and > CREATE FUNCTION? Being able

[HACKERS] Shortcut for defining triggers

2005-01-23 Thread Jim C. Nasby
Sorry if this is old, but I couldn't find it in the archives... How difficult would it be to provide a means to define a trigger in one statement? Something like a combination of CREATE TRIGGER and CREATE FUNCTION? Being able to define them seperately is awesome for generic cases where you can use