[GENERAL] SELECT ... FOR UPDATE

2003-12-20 Thread Guillaume Houssay
I need som ehelp concerning queries using SLEECT ... FOR UPDATE   I have two tables (see description below)   One is the table of reference, the other one is a table where i have daily infoirmation   I want to check the differences on the two tables based on the fields omc_index and bsc for

[GENERAL] about serial

2003-11-14 Thread Guillaume Houssay
I am using the version 7.3.4   In some tables, I have serial to manage a unique identifier.   As an example I have a column calld id_data as a serial4.   I have in my tables 30 rows with id_data from 1 to 30   Then I delete rows with id 10 and 11. Then I vaccum the table. I create some new

[GENERAL] Alter table

2003-07-30 Thread Guillaume Houssay
I am looking for the SQL query to add a column in a table and having the column at specific position in the table (not at the end of the table).   Do you have any idea ?   GH