[GENERAL] How can I alter a function?

Hi, How can I change the definition of a function without breaking all tables, which use the function? Sascha

[GENERAL] ALTER FUNCTION

Hi, are there plans for an ALTER FUNCTION statement for Postgresql? I think functions are completely unuseable, when it is not possible to change the definition of a function. A bugfix in a function requires the export of all data, a redefinition of the function and a complete reimport. Or is

[GENERAL] CREATE TRIGGER ON UPDATE

Hi, Isn't it possible to change the data of a row from it's trigger function? I would like to have some update statistics in a database. So I creeated a basetable with a number_of_updates attribute. Then I created a child tables, that inherits the attributes. In order to update the attributes

Re: [GENERAL] ALTER FUNCTION

Adriaan Joubert <[EMAIL PROTECTED]> writes: | Just drop the function, drop all triggers that use the function, | re-create the function and recreate all triggers. If the function is | called by other PL functions, you need to drop and re-install those as | well. If you keep them all in a big fil

Re: [GENERAL] ALTER FUNCTION

Holger Klawitter <[EMAIL PROTECTED]> writes: | > are there plans for an ALTER FUNCTION statement for Postgresql? I | > think functions are completely unuseable, when it is not possible to | > change the definition of a function. A bugfix in a function requires | > the export of all data, a rede

[GENERAL] operator *=

Hi, I have two tables "user_t" and "email_alias_t". The "user_t" table has the two fields "last_name" and "linux_login" and the "email_alias_t" table has the two fields "login" and "alias". In some rows in the "user_t" table the entry "linux_login" is NULL. Now I need all rows from "user_t" an

[GENERAL] Function arguments

Hi, is there a way to define a function, that accepts a TEXT value and NULL as an argument? bis später... Sascha

[GENERAL] bool and NOT

Hi, how should I write this: todolist=# select name from tasks_t where id = 5 and NOT done; ERROR: argument to NOT is type 'numeric', not 'bool' bis später... Sascha