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

CREATE TYPE with array

From: Wolfgang Drotschmann <drotschm(at)fgan(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: CREATE TYPE with array
Date: 2003-07-22 07:02:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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 (

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?



pgsql-novice by date

Next:From: Saulius SkruibisDate: 2003-07-22 12:02:30
Subject: Localization
Previous:From: Tom LaneDate: 2003-07-22 05:48:04
Subject: Re: query string returned when no records matched

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