CREATE TYPE with array
| От | Wolfgang Drotschmann |
|---|---|
| Тема | CREATE TYPE with array |
| Дата | |
| Msg-id | 3F1CE17E.E79DEA2F@fgan.de обсуждение исходный текст |
| Ответы |
Encrypted data.
Re: CREATE TYPE with array |
| Список | pgsql-novice |
Hi folks,
I tried to create a new type with an array in it. So I took an example
from (the german translation of) "PostgreSQL: Introduction and Concepts"
by Bruce Momjian.
This example says:
create type int4array (
input=array_in,output=array_out,
internallength=variable,element=int4
);
Now, psql complains:
ERROR: TypeCreate: function array_out(int4array) does not exist
I'm using PostgreSQL 7.3.2 (came with SuSE Linux 8.1).
Have things changed, or did I overlook something?
If I ask psql
\df array
array_out (among others) appears in the list of functions.
Myfirst guess is that array_{in,out} is somehow predefined, so that I
have not to define functions by hand - or is this wrong?
Thanks!
Wolfgang
В списке pgsql-novice по дате отправления: