Received: from localhost (IDENT:root@hectic-2.jpl.nasa.gov [128.149.68.204]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA91440 for ; Thu, 20 Jan 2000 10:16:21 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id PAA26921; Thu, 20 Jan 2000 15:24:17 GMT Sender: lockhart@hub.org Message-ID: <388728A1.25C98138@alumni.caltech.edu> Date: Thu, 20 Jan 2000 15:24:17 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Kovacs Zoltan , pgsql-sql@postgresql.org Subject: inserting values into arrays References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit (Message from Zoltan Kovacs; note to Zoltan: try subscribing to the "pgsql-loophole" mailing list, which should let you post to any of the other lists) > ---------- Forwarded message ---------- > Date: Thu, 20 Jan 2000 09:16:48 +0100 (CET) > From: Kovacs Zoltan > To: pgsql-sql@postgresql.org > Subject: inserting values into arrays > > I unsubscribed pgsql-sql for some days, so I don't know whether this > problem is reported already or not. > > I am trying to write a function for making group and user creation > easier. I would like to insert a new value after the existing ones in the > field "grolist" in the table "pg_group". > > I tried a few solutions without success: > > a) Defining a variable in a plpgsql function with type _int4. But > the command SELECT INTO refused to take the array up. Or, if I can do > this, how can I append a row after the others? > > b) The other idea was to get the values step by step from the array, > making a varchar type variable with the values and the other neccessary > punctuation ("{", "'", ",", "}"), and then perform an update on the right > row of pg_group. But I realized that there is no varchar->_int4 converter > in Postgres yet, unfortunately. > > The strange thing is that I can do almost everything by typing the queries > across the psql frontend, but from functions nothing (I think it is due to > there is no varchar->_int4 conversion) . > > What should I do? > > Thanks in advice, > Kovacs, Zoltan