Re: Number or parameters for functions - limited to 32 ?

From: imageguy <imageguy1206(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Number or parameters for functions - limited to 32 ?
Date: 2008-04-14 12:09:52
Message-ID: a42f74ae-dd5d-48e1-87e4-2d06b1892df0@p25g2000pri.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Ah, but it's a record, so pass a record type in:
>
> CREATE TYPE cobol_file_type AS (a integer, b text, c varchar, d date);
> CREATE FUNCTION build_tables1(c cobol_file_type)...
>
> Each existing table has its own type defined too (with the same name),
> which might save you some time.
>
> --
>    Richard Huxton
>    Archonet Ltd

This was exactly the solution that worked. We used the tables record
type.
Thanks again for the tip.
g.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2008-04-14 12:21:35 Re: The default text search configuration will be set to "simple" ?
Previous Message Harald Fuchs 2008-04-14 09:21:58 generate_series woes