to copy a record
От
Jay O'Connor
Тема
to copy a record
Дата
Msg-id
20030604113636.G874@altaica
Список
Дерево обсуждения
to copy a record "Jay O'Connor" <joconnor@cybermesa.com>
Re: to copy a record "Jim C. Nasby" <jim@nasby.net>
Re: to copy a record "Jay O'Connor" <joconnor@cybermesa.com>
Re: to copy a record "Jim C. Nasby" <jim@nasby.net>
All, I want to copy a record, changing only a few fields. I was going to do this with a plpgsql function, just by selecting the record I want copied into a variable, changing the field I need, and doing an INSERT My problem is that I'd like to do it without having to explicitly name each field in the INSERT I'd like to do something like ... DECLARE copyRec RECORD; BEGIN SELECT INTO copyRec... copyRec.field1 = newValue; INSERT INTO myTable VALUES (copyRec) <--- and nor have to list each field like: VALUES (copyRec.field1, copyRec.field2...) Any way of doing that? Thanks Take care, Jay
В списке pgsql-general по дате отправления