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: | Raw Message | Whole Thread | 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? |