| From: | Sbastien BOUTELOUP <Sebastien(dot)Bouteloup(at)upmf-grenoble(dot)fr> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | What return type for an insertion function? |
| Date: | 1999-08-12 13:05:00 |
| Message-ID: | 99081215071404.31731@iepe-pc18.upmf-grenoble.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)mail(dot)usis(dot)bkc(dot)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?
-----------------------------------------
Sbastien BOUTELOUP
stagiaire l'UFR DGES
lve ingnieur 2me anne ENSIMAG
tl: 04.76.51.49.61
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-08-12 13:23:02 | Re: [SQL] UNIQUE constraint |
| Previous Message | Bart Ogryczak | 1999-08-12 12:32:22 | converting text to float? |