X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AA3BDD9028 for ; Fri, 14 Oct 2005 09:48:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81573-05 for ; Fri, 14 Oct 2005 12:48:04 +0000 (GMT) Received: from smtpout07.attiva.biz (smtpout07.attiva.biz [85.37.16.5]) by svr1.postgresql.org (Postfix) with ESMTP id 08A05D8CE2 for ; Fri, 14 Oct 2005 09:48:05 -0300 (ADT) Received: from FBCMFE02B08.fbc.local ([192.168.30.96]) by smtpout07.attiva.biz with Microsoft SMTPSVC(6.0.3790.211); Fri, 14 Oct 2005 14:48:56 +0200 Received: from dream ([81.74.60.30]) by FBCMFE02B08.fbc.local with Microsoft SMTPSVC(6.0.3790.211); Fri, 14 Oct 2005 14:48:40 +0200 Message-ID: <002801c5d0bd$7e640e50$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: sql function Date: Fri, 14 Oct 2005 14:47:53 +0200 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C5D0CE.41A7BF00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-OriginalArrivalTime: 14 Oct 2005 12:48:41.0091 (UTC) FILETIME=[9A96FD30:01C5D0BD] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.391 required=5 tests=[AWL=0.363, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/161 X-Sequence-Number: 23014 This is a multi-part message in MIME format. ------=_NextPart_000_0025_01C5D0CE.41A7BF00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have 2 schemas "operativo" and "autore" and they both have a table = "PECDT00"=20 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;=20 insert into operativo.PECDT00 (select * from autore.PECDT00); what can i use ad the return type?? thank u =20 ------=_NextPart_000_0025_01C5D0CE.41A7BF00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

i want to create a function with the = following sql=20 command (using the programme pgadmin 3) in pgadmin 3 there is a small = wizard to=20 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=20 operativo.PECDT00 (select * from autore.PECDT00);

what can i use ad the return = type??

thank u

------=_NextPart_000_0025_01C5D0CE.41A7BF00--