Received: from trillium.nmsu.edu (trillium.NMSU.Edu [128.123.5.15])
	by hub.org (8.8.8/8.8.8) with ESMTP id TAA20502
	for <pgsql-sql@postgresql.org>; Tue, 22 Sep 1998 19:40:41 -0400 (EDT)
	(envelope-from brook@trillium.NMSU.Edu)
Received: (from brook@localhost)
	by trillium.nmsu.edu (8.8.8/8.8.8) id RAA15385;
	Tue, 22 Sep 1998 17:40:39 -0600 (MDT)
Date: Tue, 22 Sep 1998 17:40:39 -0600 (MDT)
Message-Id: <199809222340.RAA15385@trillium.nmsu.edu>
X-Authentication-Warning: trillium.nmsu.edu: brook set sender to
	brook@trillium.nmsu.edu using -f
From: Brook Milligan <brook@trillium.NMSU.Edu>
To: pgsql-sql@postgresql.org
Subject: arrays

Is it possible to add an element (or more than one element) to an
array in an UPDATE?

For example, suppose I have a field like

    a   int[]

and it contains the following

    { 1, 2, 3 }

Can I UPDATE this by adding 4 to the end so that it is now

    { 1, 2, 3, 4 }

Cheers,
Brook