NOTIFY "string" from rule
От | Jeff Boes |
---|---|
Тема | NOTIFY "string" from rule |
Дата | |
Msg-id | 9h05l0$1bke$1@news.tht.net обсуждение исходный текст |
Ответы |
Re: NOTIFY "string" from rule
|
Список | pgsql-sql |
Say my table looks like: CREATE TABLE foo(status char(5), name char(5)); and I want to have a rule that does this: CREATE RULE nf_foo AS ON INSERT TO foo DO NOTIFY new.status || '_' || new.name; Any hints? My first attempt was to write a function: CREATE FUNCTION bar(foo) RETURNS TEXT AS 'SELECT $1.status || ''_'' || $1.name;' LANGUAGE 'sql'; and then change the last line of the rule to NOTIFY bar(new); but no luck. I would like to avoid writing a bunch of rules to process each combination of 'status' and 'name' (at least they're each a limited set!). -- Jeff Boes vox 616.226.9550 Database Engineer fax 616.349.9076 Nexcerpt, Inc. jboes@nexcerpt.com
В списке pgsql-sql по дате отправления: