hubert depesz lubaczewski wrote:
On 1/3/07, Richard Huxton <dev@archonet.com> wrote:
If you do that separately at the start of the process, (one query per
custom column in the old table) then it becomes straightforward.
no, because meaning of "col1" in advert_custom_fields is different for each
record.
for one record it's codename might be "email" for another record it
might be
"engine size".
And is that not what's stored in "v_category_custom_fields"? So you can
do the transformation and get (advert_id=1, codename='col1',
value='vvv') then use v_category_custom_fields to update the 'col1' part.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
