What return type for an insertion function?
От | Sébastien BOUTELOUP |
---|---|
Тема | What return type for an insertion function? |
Дата | |
Msg-id | 99081215071404.31731@iepe-pc18.upmf-grenoble.fr обсуждение исходный текст |
Список | pgsql-sql |
> CREATE TRIGGER name { BEFORE | AFTER } { event [OR > ...] } ON table FOR EACH { ROW | STATEMENT } > EEXECUTE PROCEDURE ( arguments ) > you should apparently create a procedure/function much of the same > as with: > CREATE FUNCTION name ( [ ftype [, ...] ] ) RETURNS rtype > AS definition LANGUAGE 'langname' > > BEGIN/END I think would be restricted to transactions. And therefore > would be considered reserved words? > > Just my idea. Haven't used triggers in Pg yet myself. You might see > under contributed things / refint (referential integrity) package > somewhere, there should be lots of triggers I assume. > > > > Emils Klotins e-mail: emils@mail.usis.bkc.lv > Systems Manager URL: http://www.usis.bkc.lv/ > USIS Riga 7 Smilsu Str., Riga LV1050, LATVIA -- OK, but if I execute an SQL query (insertion), there is no return type for the creation of the function. Is it possible to create a procedure? ----------------------------------------- S�bastien BOUTELOUP stagiaire � l'UFR DGES �l�ve ing�nieur 2�me ann�e ENSIMAG t�l: 04.76.51.49.61
В списке pgsql-sql по дате отправления: