From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: select from table and add rows.
Date: Fri, 6 Jul 2007 11:02:57 -0400
Message-ID: <20070706150257.GS20115@phlogiston.dyndns.org> (raw)
In-Reply-To: <200707061425.09074.gary.stainburn@ringways.co.uk>
References: <200707061425.09074.gary.stainburn@ringways.co.uk>
On Fri, Jul 06, 2007 at 02:25:08PM +0100, Gary Stainburn wrote:
> This sets up an array with some pseudo values and then populates it with
> *proper* values from a table.
>
> How's the best way to do this all within SQL.
I'm obviously not understanding the question properly, because I
think you want ot set up a PHP array with values from your table,
without using PHP. Which would of course make no sense. Do you
mean, how do you populate an array data type with data from individual
database columns?
A
--
Andrew Sullivan | ajs@crankycanuck.ca
However important originality may be in some fields, restraint and
adherence to procedure emerge as the more significant virtues in a
great many others. --Alain de Botton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: select from table and add rows.
In-Reply-To: <20070706150257.GS20115@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox