Re: Anyarray with mixed data types inside of a PL/PLSQL function parameter - Mailing list pgsql-novice

From Tom Lane
Subject Re: Anyarray with mixed data types inside of a PL/PLSQL function parameter
Date
Msg-id 19227.1109701620@sss.pgh.pa.us
Whole thread Raw
In response to Anyarray with mixed data types inside of a PL/PLSQL function parameter  ("Christian Hofmann" <christian.hofmann@gmx.de>)
List pgsql-novice
"Christian Hofmann" <christian.hofmann@gmx.de> writes:
> select test(ARRAY[['my_row'::text, 'mytext'::text, false::boolean, 'thats my
> value'::text],['my_row2'::text, 'integer'::text, false::boolean,
> 3::integer]])

You can't have an "array" whose elements are of different datatypes.

            regards, tom lane

pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: Re: Please help
Next
From:
Date:
Subject: Re: Please help