Aggregate UDF

Article View: borland.public.interbase.opensource

Article #298

Back to borland.public.interbase.opensource Previous Next

#298

From: Eduardo Gamboa
Date: Fri, 15 Jul 2005 18:51

21 lines
1279 bytes

Hi everybody,

I would like to know if there is a way to make an aggregate udf like SUM().
Example:
Table1
Field1    Field2
A    1
A    1
A    3
if I use: SELECT Field1, SUM(Field2) From Table1 Group by Field1
I got:
A    5
But I like something like: SELECT Field1, BOOL_OR(Field2) From Table1 Group 
by Field1
Result:
A    3

Please Help.

Best regards.
Eduardo Gamboa

Technical Details

Message-ID: <42d805bc$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news.alt.net!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,b507b61fc2929d93,start
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Eduardo Gamboa" <eduardo.gamboa@hotmail.com>
Newsgroups: borland.public.interbase.opensource
Subject: Aggregate UDF
Date: Fri, 15 Jul 2005 13:51:41 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
NNTP-Posting-Host: 200.31.27.34
Message-ID: <42d805bc$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1121453500 200.31.27.34 (15 Jul 2005 11:51:40 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news.alt.net!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail