I have the following function:
CREATE FUNCTION public.auto_incremento() RETURNS trigger AS 'begin new.id = (select (max(id) + 1) from teste); return new; end;' LANGUAGE 'plpgsql' I created a trigger that uses this function, but i want to the function be usefull for all tables and not only to tbale teste. Someone know how ???
Pedro Igor
|
- [SQL] sql query manjul katare
- [SQL] SQL Query Miguel González
- Re: [SQL] SQL Query Miguel González
- Re: [SQL] SQL QUERY Pedro Igor
- Re: [SQL] SQL QUERY Achilleus Mantzios
- Re: [SQL] SQL QUERY Achilleus Mantzios
- [SQL] sql query Vijay Uppal
- Re: [SQL] sql query Christoph Haller
- [SQL] SQL query Paul Czubilinski
- [SQL] SQL Query beyaNet Consultancy
- Re: [SQL] SQL Query Bruno Wolff III