Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-27 Thread Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]
To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] PSQL: Getting both aggregation and individual rows Seems like I will have to use a temporary table for this purpose. But if there is another way, I would be interested in knowing it. Josef Hi! Is there a simple way

Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-27 Thread Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]
-support@yahoogroups.com] Sendt: 21. oktober 2014 09:39 Til: Firebird Support Emne: [firebird-support] PSQL: Getting both aggregation and individual rows Hi! Is there a simple way to get an aggregation of some query as well as the individual rows from within a PSQL? I.e., I have a stored

Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-27 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Hi! I tried this approach before, but it violates my only run GET_DATA once requirement :-( Well, with EXECUTE BLOCK and ORDER BY it may be possible to satisfy your MIN requirement, but I can't logically understand how it even theoretically wold be possible to know the SUM before having gone

Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-27 Thread Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]
On 27.10.2014 10:35, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: Hi! I tried this approach before, but it violates my only run GET_DATA once requirement :-( Well, with EXECUTE BLOCK and ORDER BY it may be possible to satisfy your MIN

[firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-21 Thread Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]
Hi! Is there a simple way to get an aggregation of some query as well as the individual rows from within a PSQL? I.e., I have a stored procedure GEN_DATA which produces individual rows (ID, Name, DateAndTime, Value). I am processing the output of GEN_DATA in another stored procedure PROCESS_DATA:

Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-21 Thread Josef Kokeš j.ko...@apatykaservis.cz [firebird-support]
Seems like I will have to use a temporary table for this purpose. But if there is another way, I would be interested in knowing it. Josef Hi! Is there a simple way to get an aggregation of some query as well as the individual rows from within a PSQL? I.e., I have a stored procedure

RE: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-21 Thread 'Edward Mendez' emendez...@nc.rr.com [firebird-support]
, 2014 4:12 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] PSQL: Getting both aggregation and individual rows Seems like I will have to use a temporary table for this purpose. But if there is another way, I would be interested in knowing it. Josef Hi

Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-21 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Fra: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com] Sendt: 21. oktober 2014 09:39 Til: Firebird Support Emne: [firebird-support] PSQL: Getting both aggregation and individual rows Hi! Is there a simple way to get an aggregation of some query as well

Re: [firebird-support] PSQL: Getting both aggregation and individual rows

2014-10-21 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Tue, 21 Oct 2014 09:39:44 +0200, Josef Kokeš j.ko...@apatykaservis.cz [firebird-support] firebird-support@yahoogroups.com wrote: Hi! Is there a simple way to get an aggregation of some query as well as the individual rows from within a PSQL? I.e., I have a stored procedure GEN_DATA which