arrays

From: Brook Milligan <brook(at)trillium(dot)NMSU(dot)Edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: arrays
Date: 1998-09-22 23:40:39
Message-ID: 199809222340.RAA15385@trillium.nmsu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Lotto 1998-09-23 12:13:20 subscribe
Previous Message Jackson, DeJuan 1998-09-22 23:09:56 RE: [SQL] To create the query for a select where one is NOT in th e other