Re: counting columns

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/28/07 10:46, pere roca wrote:
> hi!
>
> I want different users to insert data and perform different analysis which
> will be inserted in an interactively created new column. The name of this
> new column should follow a logic name such as: fxanalysis_1 for the first
> user that perform the analysis called fx, fxanalysis_2 for the second...
> To get it, I think I should construct a function that counts how many
> columns have their name starting with fxanalysis.
>    If count >=1, then alter table adding a new column with name fxanalysis_2
>    and so on...
>    One of the questions: how to COUNT COLUMNS? I can rename, add, alter
> columns... but count?

You'll need to go into the catalog.

Your idea, though, is poor.  You should make a second table, where
the key is the same as the master table, plus a "sequence number".

If you want to do it your way, though, PostgreSQL supports array types.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG1gSbS9HxQb37XmcRAqw+AKC8lDaQZ6IQ2ugVZzfxuT8TlGeHvQCgsLic
esN5w79t4bGAnURm+Nulq20=
=PBHq
-----END PGP SIGNATURE-----