--- In ib-support@yahoogroups.com, "Marco Menardi" <mmenaz@l...>
wrote:

> --- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>

wrote:

> > Hi Marco,
> >
> > > Hi, I can't test FB RC2, so, since there is no mention in

"What's new"

> > > document, does anyone here know if this syntax is now correct

(and

> > > works ;))?
> > > insert into PhoneList(client_id)
> > > select client_id from Clients order by birthday
> >
> > Why the ORDER BY?
> >
>
> For instance, I have triggers that prevent inserting people jounger
> than the older in the table, or force code to be longer thant the
> previous entered, and so on. When I need to "copy" the data from one
> table to the other without "order by" I will not know the order in
> which the records are extracted and then inserted, so trigger
> generated exception can be risen.

Marco, though I see in your arguments only intention to use ordering
instead filtering, what IMHO generally is not good practice, I can say
you in FB1.5 you can use order by within insert from select and within
subselects with First 1. I was one of those who supported this feature
when it was discussed, but personally I see it's usage with First only
- non-relational filtering technique included into SQL server toolkit
requires further extensions of old technique to be usefully used, no
more.

Best regards, Alexander.