Re: Number or parameters for functions - limited to 32 ? - Mailing list pgsql-general

From imageguy
Subject Re: Number or parameters for functions - limited to 32 ?
Date
Msg-id a42f74ae-dd5d-48e1-87e4-2d06b1892df0@p25g2000pri.googlegroups.com
Whole thread Raw
In response to Number or parameters for functions - limited to 32 ?  (imageguy <imageguy1206@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Dump/Transfer Sequence Problems
Next
From: Richard Huxton
Date:
Subject: Re: The default text search configuration will be set to "simple" ?