Re: [GENERAL] Fwd: PSQL Help from your biggest fan

2012-08-18 Thread Tom Lane
Raghavendra writes: >> I tried your code in Postgres 8.2: > 8.2 ?, Seems you have tested it in very Old version. Indeed. The example works OK for me too, in 8.2.23 which is the last of that release branch. regards, tom lane -- Sent via pgsql-general mailing list (pgs

Re: [GENERAL] Fwd: PSQL Help from your biggest fan

2012-08-17 Thread Raghavendra
> > > I tried your code in Postgres 8.2: > 8.2 ?, Seems you have tested it in very Old version. > CREATE OR REPLACE FUNCTION _final_mode(anyarray) > > RETURNS anyelement AS > > $BODY$ > > SELECT a > > FROM unnest($1) a > > GROUP BY 1 > > ORDER BY COUNT(1) DESC, 1 > > LIMIT 1; > > $BODY$ > > LAN

[GENERAL] Fwd: PSQL Help from your biggest fan

2012-08-17 Thread Evan Stanford
Hi Grzegorz and Pgsql-General, Can you forward this to Scott Bailey? I tried sending it to his old email, but it seems to be closed. Or could you answer my question yourself? Thank you so much, Evan Stanford -- Forwarded message -- From: Evan Stanford Date: Fri, Aug 17, 2012 at 3