What return type for an insertion function?

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

Browse pgsql-sql by date

  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?