Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E6A519FC0BE for ; Fri, 11 May 2007 11:00:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 50996-02-4 for ; Fri, 11 May 2007 11:00:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smarty.gabriel.co.hu (smarty.gabriel.co.hu [195.70.37.16]) by postgresql.org (Postfix) with ESMTP id 0FEBA9FB348 for ; Fri, 11 May 2007 11:00:46 -0300 (ADT) Received: from localhost (smarty [127.0.0.1]) by smarty.gabriel.co.hu (Postfix) with ESMTP id 54458597B1 for ; Fri, 11 May 2007 16:00:39 +0200 (CEST) Received: from smarty.gabriel.co.hu ([127.0.0.1]) by localhost (smarty [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 24226-01-4 for ; Fri, 11 May 2007 16:00:39 +0200 (CEST) Received: from gabriel-laptop (customer-174.radio-net.hu [217.113.54.174]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smarty.gabriel.co.hu (Postfix) with ESMTP id 1000F40D9 for ; Fri, 11 May 2007 16:00:39 +0200 (CEST) Date: Fri, 11 May 2007 16:00:37 +0200 From: =?UTF-8?B?R8OhYnJpZWwgw4Frb3M=?= To: pgsql-sql@postgresql.org Subject: PL/PGSQL Record type question Message-ID: <20070511160037.1c09160e@gabriel-laptop> Organization: I-Logic Ltd X-Mailer: Claws Mail 2.9.1 (GTK+ 2.10.11; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at gabriel.co.hu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/82 X-Sequence-Number: 28362 Hi, How should I define a record type (there is no table with this record type) programmatically in pl/pgsql? I'd like to return a record with 3 string elements, 2 integers and 1 date. Rgds, Akos --=20 =C3=9Cdv=C3=B6zlettel, G=C3=A1briel =C3=81kos -=3DE-Mail :akos.gabriel@i-logic.hu|Web: http://www.i-logic.hu =3D- -=3DTel/fax:+3612367353 |Mobil:+36209278894 =3D-