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? Thanks in advance, Pere -- View this message in context: http://www.nabble.com/counting-columns-tf4342021.html#a12368870 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
