On Fri, Jun 29, 2012 at 3:29 AM, Richard Huxton <dev@xxxxxxxxxxxx> wrote: > On 29/06/12 09:01, adasko98 wrote: >> >> Hi >> In first sorry for my english :) I have got a problem with >> notify/listener. >> I do a function which returns a trigger. Everything is ok but when i want >> send in a second parameter a variable NOTIFY say: "syntax error" > > >> Notify demoApp, 'some text'; > > >> n_user :='sda'; >> Notify demoApp, n_user ;<----here is a problem > > > Looks like a limitation of the plpgsql parser, perhaps even counts as a bug. > You can work around it with EXECUTE though, something like: > cmd := 'NOTIFY demoApp, ' || quote_literal(n_user); > EXECUTE cmd; > or just > EXECUTE 'NOTIFY demoApp, ' || quote_literal(n_user); also see pg_notify() function. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
