[GENERAL] interface for "non-SQL people"

hi, some nice tool over there to let non-SQL knowing people to construct their queries? I'm using pgAdmin III but I know some SQL. there is no other option than constructing an HTML with forms, drop-down menus...? thanks, pERE -- View this message in context: http://www.nabble.com/i

Re: [GENERAL] simple limit of decimals

Andreas Kretschmer-4 wrote: > > In response to pere roca : >> >> hi all, >> >> I update a column based on a division over two real values. It causes a >> huge >> number of decimals that I wanna to limit. >> >> UPDATE point_pol SET taxa_record

[GENERAL] simple limit of decimals

hi all, I update a column based on a division over two real values. It causes a huge number of decimals that I wanna to limit. UPDATE point_pol SET taxa_record = ((SELECT ((CASE WHEN numtax>0 THEN numtax/numreg ELSE 1 END))) where userid='hello' taxa_record values are real and with real I can

re[GENERAL] moving a portion of text

hi, I have a column with full of data like ATB-OO NCK-TT how can I easily remove the "-" ? it seems that the "-" is allways the fourth letter. thanks, Pere -- View this message in context: http://www.nabble.com/removing-a-portion-of-text-tp20067248p20067248.html Sent from the Postg

[GENERAL] COPY for .CSV files problem

Hi everybody, I want to enter a .CSV file using COPY comand and plpgsql. It enters lat,lon and some data. In the CSV data there is no field (such as "user_name" or current_time) that allow distinguish future queries for different users (ex: select x,y from table where user_name=z; after enteri

[GENERAL] using COPY, .CSV and ¿catalog?

Hi everybody, I want to enter a .CSV file using COPY comand and plpgsql. It enters latitude,longitude and some data. In the CSV data there is no field (such as "user_name" or current_time) that allow distinguish future queries for different users (ex: select x,y from table where user_name=z;

[GENERAL] counting columns

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