| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Henry Combrinck <henry(at)metroweb(dot)co(dot)za> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Passing RECORD variable from func1() to func2() |
| Date: | 2004-09-06 21:23:31 |
| Message-ID: | 20040906212331.GB24886@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 06, 2004 at 10:39:54PM +0200, Henry Combrinck wrote:
> Can you give an example of what a "named rowtype" is? Are you refering to
> creating some kind of custom TYPE, and then passing that to
> func2(custom_type_row)?
You can use a table's rowtype, that is, a type that has the name of the
table and the same column types. Or you can create a "standalone type" with
CREATE TYPE foo AS (f1 int, f2 text, ...)
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NTPT | 2004-09-06 22:23:56 | Re: Index on TEXT versus CHAR(32)... fast exact TEXT matching |
| Previous Message | Tom Lane | 2004-09-06 21:17:55 | Re: Passing RECORD variable from func1() to func2() |