Using LASTOID in one query
От | Eckhard Hoeffner |
---|---|
Тема | Using LASTOID in one query |
Дата | |
Msg-id | 20020520140835.GA6211@fifoost.org обсуждение исходный текст |
Ответы |
Re: Using LASTOID in one query
Re: Using LASTOID in one query |
Список | pgsql-sql |
Is there a possibility to use the last OID from PHP within one query? I have two tables like the following: table_a: number1 serial PRIMARY KEY a_text text table_b: number1 integer REFERENCES table_a, b_text text I am retrieving data like a_text = something b_text = something else With psql I would do the following: BEGIN; INSERT INTO table_a (a_text) VALUES ('something'); INSERT 224490 1 SELECT number1 FROM table_a WHERE oid = 224490;number1 ------- 9 (1 row) INSERT INTO table_b (number1, b_text) VALUES (9, 'something else'); INSERT 224491 1; COMMIT; If I am using php, the only solution I know is: 1. make the first INSERT, execute it 2. get the last oid and make the next query, execute it 3. make the second INSERT This are 3 queries and I can not do it within a transaction. -- --//--\\-- Eckhard Hoeffner e-hoeffner@fifoost.org Tal 44 D-80331 München
В списке pgsql-sql по дате отправления: