X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A81C1D1B4AE for ; Mon, 1 Dec 2003 04:10:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 28941-08 for ; Mon, 1 Dec 2003 00:09:45 -0400 (AST) Received: from spinoza.ime.usp.br (spinoza.ime.usp.br [143.107.45.30]) by svr1.postgresql.org (Postfix) with SMTP id D6EC3D1B4E0 for ; Mon, 1 Dec 2003 00:09:42 -0400 (AST) Received: (qmail 20130 invoked by uid 0); 1 Dec 2003 04:04:38 -0000 Received: from coliseu.linux.ime.usp.br (192.168.240.9) by spinoza.linux.ime.usp.br with SMTP; 1 Dec 2003 04:04:38 -0000 Received: (qmail 15062 invoked from network); 1 Dec 2003 04:09:06 -0000 Received: from epicurus.linux.ime.usp.br (192.168.240.44) by coliseu.linux.ime.usp.br with QMQP; 1 Dec 2003 04:09:06 -0000 Date: Mon, 1 Dec 2003 02:09:36 -0200 From: Andre Yoshiaki Kashiwabara To: pgsql-sql@postgresql.org Subject: ECPG and User-defined Types. Message-ID: <20031201040936.GA27928@epicurus> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.28i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/40 X-Sequence-Number: 16206 Hi, How can i use a user-defined type in ECPG code ? For example: I have the following stored-procedure: CREATE FUNCTION teste(MY_TYPE) RETURNS boolean; where MY_TYPE is: CREATE TYPE MY_TYPE AS (id_person INT8, id_book INT8); Now, i am having problem with: EXEC SQL SELECT teste(:asd); -- Andre