Re: Returning with a userd defined type (PL/pgSQL)

From: "Egyud Csaba" <csegyud(at)freemail(dot)hu>
To: "Joe Conway" <mail(at)joeconway(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Returning with a userd defined type (PL/pgSQL)
Date: 2003-04-28 01:05:23
Message-ID: 000a01c30da6$99d4d3e0$800a0a0a@xxx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe,

thank you for your help. It was really simple.

-- Csaba

----- Original Message -----
From: "Joe Conway" <mail(at)joeconway(dot)com>
To: "Együd Csaba" <csegyud(at)freemail(dot)hu>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, April 25, 2003 7:35 AM
Subject: Re: [GENERAL] Returning with a userd defined type (PL/pgSQL)

> Együd Csaba wrote:
> > ResultR MY_TYPE;
>
> Not the best of error messages perhaps, but change the above line to:
>
> ResultR MY_TYPE%ROWTYPE;
>
> HTH,
>
> Joe
>
>
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.435 / Virus Database: 244 - Release Date: 2002.12.30.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Baguette 2003-04-28 06:40:55 Re: Cannot use the queries buffer of psql... :-(
Previous Message Sean Chittenden 2003-04-27 21:00:53 Re: Resetting a sequence's last value...