Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 96E8E9FC113 for ; Fri, 11 May 2007 11:42:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 42164-04 for ; Fri, 11 May 2007 11:42:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smarty.gabriel.co.hu (smarty.gabriel.co.hu [195.70.37.16]) by postgresql.org (Postfix) with ESMTP id 68BBA9FBF11 for ; Fri, 11 May 2007 11:42:52 -0300 (ADT) Received: from localhost (smarty [127.0.0.1]) by smarty.gabriel.co.hu (Postfix) with ESMTP id 3CB6A59765 for ; Fri, 11 May 2007 16:42:50 +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 06408-02-2 for ; Fri, 11 May 2007 16:42:50 +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 550F53E2F9 for ; Fri, 11 May 2007 16:42:49 +0200 (CEST) Date: Fri, 11 May 2007 16:42:42 +0200 From: =?UTF-8?B?R8OhYnJpZWwgw4Frb3M=?= To: pgsql-sql@postgresql.org Subject: Re: PL/PGSQL Record type question Message-ID: <20070511164242.7ed1f046@gabriel-laptop> In-Reply-To: <1f30b80c0705110709u73519990gd6623c6a4c81ee55@mail.gmail.com> References: <20070511160037.1c09160e@gabriel-laptop> <1f30b80c0705110709u73519990gd6623c6a4c81ee55@mail.gmail.com> 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/84 X-Sequence-Number: 28364 On Fri, 11 May 2007 19:09:07 +0500 imad wrote: > You might be looking for PostgreSQL RECORD data type. Thanks. Give me an example please. I saw the documentation already. >=20 > --Imad > www.EnterpriseDB.com >=20 > On 5/11/07, G=C3=A1briel =C3=81kos wrote: > > 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. --=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-