sql function

From: "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: sql function
Date: 2005-10-14 12:47:53
Message-ID: 002801c5d0bd$7e640e50$1102a8c0@dream
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have 2 schemas "operativo" and "autore" and they both have a table "PECDT00"

i want to create a function with the following sql command (using the programme pgadmin 3) in pgadmin 3 there is a small wizard to fill when u create a function and u have to add the return type..

this is the sql statement i wanna do

DELETE FROM operativo.PECDT00;
insert into operativo.PECDT00 (select * from autore.PECDT00);

what can i use ad the return type??

thank u

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2005-10-14 13:18:19 Re: sql function
Previous Message David Pradier 2005-10-14 12:43:34 Re: Design problem : using the same primary keys for inherited objects.