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
-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
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
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
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:
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
, 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
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
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