Re: HELP: Sorting in INSERT-statements
Date: 1995/10/20
Message-ID: <4687bm$5bo_at_news.Austria.EU.net>#1/1
Hi,
it appears to me you want the same order as with "a_column". So
why do you need another table? Just use your old table with
your order phrase as you try with your insert.
If the ordering is not unique as your a_column might arrive
more then once, so you would have to use more columns for your
order phrase.
You will use an order phrase with your table just inserted,
won't you?
If you want to merge more than that one table into your printer
table, so you need _one_ value per insert statement.
In other words: Do not use nextval for every line, rather use
nextval for every insert! This preserves the original order.
(You dont want the order of all inserts? Then use a_column as
before).
Is there something I did not think of?
Regards
Wolfgang
! Wolfgang Wagner ! Email: ww_at_unisys.co.at
! Unisys Österreich GmbH !
! Seidengasse 33-35 ! Phone: +43-1-52121-327
! POB 27 ! Fax: +43-1-52121-590
! A-1071 Vienna, Austria ! P.S. I do not speak for Unisys.
Received on Fri Oct 20 1995 - 00:00:00 CET