-----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----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
