Re: [GENERAL] Trying to move away from Firebird

2016-02-12 Thread ioan ghip
Thanks for the links Adrian. I was able to convert a bunch of triggers after reading the documentation. Yes, it looks like POST_EVENT is the smaller brother of NOTIFY. http://www.postgresql.org/docs/9.0/static/sql-notify.html

Re: [GENERAL] Trying to move away from Firebird

2016-02-12 Thread Adrian Klaver
On 02/12/2016 02:11 PM, ioan ghip wrote: I was able to create all the domains, tables, views, etc, but I have trouble creating stored procedures and triggers. Also, a question, does Postgres support events, for example in Firebird I could do something like this and then receive the event in the G

[GENERAL] Trying to move away from Firebird

2016-02-12 Thread ioan ghip
I was able to create all the domains, tables, views, etc, but I have trouble creating stored procedures and triggers. Also, a question, does Postgres support events, for example in Firebird I could do something like this and then receive the event in the GUI: if ((NEW.MUSED_M_>=NEW.MLIMIT_M_) an