Definitely SQL*PLUS, you're right.
I managed to create a report as a UNION select between data and SUMs of data
queries, with relevant fields for GROUPing and ORDERing. I would have liked to
be able to get these "relevant fields" shown only once, so I started to check
what is available, and stu
Hi All,
Is there in PostgreSQL an equivalent of Oracle's BREAK/COMPUTE reporting
feature?
Thanks,
SxN
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am running 8.1.4 and the o.* notation works.
Thanks again,
Sorin
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
Thank you, indeed
SELECT * INTO o ...
solves it.
One last question, if I may:
both expected_stuff and archive.expected_stuff are
defined as:
( source CHAR(2);
warehouse CHAR(1);
stuff SMALLINT;
packslip CHAR(12)
);
and o is expected_stuff%ROWTYPE
Having the same structure, I put
INSERT
Hi All,
I'm trying to write a stored PLPG/SQL procedure:
CREATE OR REPLACE FUNCTION
arch_expected_stuff(CHAR(12)) RETURNS VOID
AS $$
-- Archives expected_stuff
-- takes packing slip
DECLARE
o expected_stuff%ROWTYPE;
BEGIN
o:= * FROM expected_stuff WHERE packslip=$1; --
LIMIT 1;
