[GENERAL] UPDATE table .....

2005-12-13 Thread Maik Trömel
/Hi, I want to update a column (integer). The value that should be set is the sum of the column I want to update and an integer column from another table with similiar information an the same primary key "gid". It should work this way: Table1+ Table2 =

[GENERAL] time zone - timestamp

2005-11-10 Thread Maik Trömel
Hello, I created a table with: "create table wrf (region integer, created_on timestamp(0) with time zone, valid_for timestamp(0) with time zone, type varchar(5), max float, min float, avg float, stddev float, var float);" then i inserted data with: "insert into wrf values ( $i, '2005-08-02 03

[GENERAL] script

2005-11-10 Thread Maik Trömel
Hello! I want to run a shell script with variables under Postgresql. An example: I want to make the following query; select * from tablename where id=1; select * from tablename where id=2; select * from tablename where id=3; select * from tablename where id=4; . Is it possible