Re: Problem with Informix 7.3
Kadlcik Vaclav wrote:
>
> I faced this problem a few week ago on 7.30.UC2 (HP-UX).
> The syntax analyzer doesn't accept this:
>
> SELECT ... procedure(aggregate_function)...
>
> I called techsup and they said it was bug = 92478 and
> would be fixed in 7.31 (7.30.UC6, too).
>
> HTH,
> Vasek
>
> > -----Original Message-----
> > From: Volker Fraenkle [SMTP:VFraenkle@cs-controlling.de]
> > Posted At: Friday, October 16, 1998 9:33 AM
> > Posted To: comp.databases.informix
> > Conversation: Problem with Informix 7.3
> > Subject: Re: Problem with Informix 7.3
> >
> > I tested this statement under IDS 7.20/HP-UX and it works fine;
> > Volker
> >
> >
> > HARINATH VENKATA schrieb:
> > >
> > > I think the function used in a select clause should be a group
> > function.
> > >
> > > I am surprised to know how it works in NT (7.2) and SCO Unix !
Until then you could try adding another layer of aggregate to fool the
parser. Try:
SELECT ..., MAX(procedure(aggregate_function))...
It might work!
Art S. Kagel