passing column name to a plpgsql function for ALTER TABLE ADD

Поиск
Список
Период
Сортировка
Искать

passing column name to a plpgsql function for ALTER TABLE ADD

От:
Alexander Kotelnikov <sacha@myxomop.com>
Дата:
Hello.

Is it possible? I would like to do something like
CREATE OR REPLACE FUNCTION add_column(name, anyelement) RETURNS integer AS '
  DECLARE 
    col_name ALIAS FOR $1;
    def_val  ALIAS FOR $2;
  BEGIN
    ALTER TABLE my_table ADD col_name def_val%TYPE;
    RETURN 0;
  END;  
' LANGUAGE plpgsql;
SELECT add_column('a', 1);
-- 
Alexander Kotelnikov
Saint-Petersburg, Russia
FAQ