At 01:56 PM 27/05/2004 +0200, you wrote:

>Hi,
>
> > > We *should* be able to use this syntax in DSQL:
> > >
> > > UPDATE blob_test
> > > SET blb_text = :zipped_file
> > > FILTER FROM -2 TO 1;
>
>Naah, won't do. Think of multiple SETs and INSERTs as
>well. A more generalized syntax would be better.
>
>How about:
>
>SET blb_text = FILTER(:zipped_file, -2, 1),
>
>INSERT INTO ... VALUES (FILTER(:zipped_file, -2, 1), ...)

What would be the purpose of introducing a totally different syntax that is
inconsistent with ESQL, which is the SQL "super-set" of DSQL?

Why do you think the existing syntax won't handle multiple column inserts
and updates?

Curious...

/heLen