Postgres Pro
Downloads
Home   >   mailing lists

arrays - Mailing list pgsql-sql

From Brook Milligan
Subject arrays
Date
Msg-id 199809222340.RAA15385@trillium.nmsu.edu
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] To create the query for a select where one is NOT in th e other
Next
From: "Lotto"
Date:
Subject: subscribe