Re: Arrays, types and prodedures - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: Arrays, types and prodedures
Date
Msg-id 162867790807250138j50ac624cw3439a7c09c0e392f@mail.gmail.com
Whole thread Raw
In response to Arrays, types and prodedures  ("Chris Hoy" <chris.hoy@hoyc.fsnet.co.uk>)
List pgsql-sql
hello


2008/7/25 Chris Hoy <chris.hoy@hoyc.fsnet.co.uk>:
>
>
> Hi
>
> I am having trouble passing arrays of types to a store procedure
> I have the following type
>
>        CREATE TYPE IndexElement AS (
>                keyname text,
>                keytype integer
>        );
>
> and the header for the store prodedure is as follows:
>
> CREATE OR REPLACE FUNCTION doIndexGroupCount(
>    indexs IndexElement[],
>    customerid INTEGER ,
>    logic INTEGER )
>
> but when I try and call it using the following code
>
>        SELECT * from doIndexGroupCount(ARRAY[('dog', 1),('cat', 1)],10,0);
>
> I get and error
>
>        ERROR: could not find array type for data type record
>
> What am I missing?
>

casting

postgres=# select ARRAY[('dog', 1),('cat', 1)]::indexelement[];        array
-----------------------{"(dog,1)","(cat,1)"}
(1 row)

regards
Pavel Stehule

> Chris
>
>
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>


pgsql-sql by date:

Previous
From: "Chris Hoy"
Date:
Subject: Arrays, types and prodedures
Next
From: "Anoop G"
Date:
Subject: Re: postgres time zone settings(time difference in Server and client)