Ann - thanks for your answer.

> The default is evaluated at compile time and turned into part of..

These would be dynamic SQL statements - any difference here?

Tom



--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

>
> tomconlon7777777 wrote:
> >
> > INSERT INTO qrytmp1 ...
> > 1. SELECT id FROM x (qtype default fires)
> > 2. SELECT id, 'C' FROM x (qtype explicit)
> > 3. SELECT id, 'C' FROM x (lose default, qtype explicit)
> >
> > Is (3) is the quickest?
>
> The default is evaluated at compile time and turned into part of
> the insert statement... I suppose you've got an extra if test
> in the inner loop, but in 2 & 3 you're evaluating two input values.
> My guess is it won't make much difference either way.
>
>
> Regards,
>
>
> Ann
>