Skip site navigation (1) Skip section navigation (2)

Re: error:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "chetan N" <chetan622(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: error:
Date: 2008-09-29 13:55:35
Message-ID: 11300.1222696535@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"chetan N" <chetan622(at)gmail(dot)com> writes:
>     CREATE TYPE emptype as(
>                                                 name text,
>                                                 id integer,
>                                                 dob date);

>     SELECT * from passingEmployeeList(ARRAY[('chethan', 1,
> '10-05-1983'),('ashok', 2, '10-05-1982')]::emptype[] );
>     ERROR:  could not find array type for data type record

That does work in CVS HEAD, but in existing releases you'll need to
spell the array constructor like this:

ARRAY[('chethan', 1,'10-05-1983')::emptype, ('ashok', 2, '10-05-1982')::emptype]

8.3 and before try to determine the array type too soon --- casting the
result of the constructor doesn't help them.

			regards, tom lane

In response to

  • error: at 2008-09-29 13:38:50 from chetan N

pgsql-general by date

Next:From: Simon RiggsDate: 2008-09-29 14:03:51
Subject: Re: pg_start_backup() takes too long
Previous:From: yann.dubostDate: 2008-09-29 13:41:33
Subject: Re: Is there a parameter to tell postgresql to not attempt to open an IPv6 socket?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group