RE: [GENERAL] No MAX function

It depends of data type - unfortunately max was not defined for ALL
appropriate types. Through

testo=> select max(bypref) from inetspec;
max
---
24

where bypref is int2.

On Sat, 6 Feb 1999, dustin sallings wrote:

> Date: Sat, 6 Feb 1999 13:10:56 -0800 (PST)
> From: dustin sallings <dustin(at)spy(dot)net>
> To: Jonny Hinojosa <Jonny(at)TCA(dot)net>
> Cc: PostGreSQL Mailing List <pgsql-general(at)postgreSQL(dot)org>
> Subject: RE: [GENERAL] No MAX function
>
> On Sat, 6 Feb 1999, Jonny Hinojosa wrote:
>
> // cdmwhere=> SELECT * FROM traplog WHERE millisid=
> // (SELECT MAX(millisid) FROM traplog
> // WHERE esn LIKE '0f:11:19:82:54:35');
> // ERROR: No such function 'max' with the specified attributes
> // cdmwhere=>
>
> What's a millisid? If it's something obscure, there may not have
> been a max() defined for it.
>
> //
> // -----Original Message-----
> // From: dustin sallings [mailto:dustin(at)spy(dot)net]
> // Sent: Saturday, February 06, 1999 2:21 PM
> // To: Jonny Hinojosa
> // Cc: PostGreSQL Mailing List
> // Subject: RE: [GENERAL] No MAX function
> //
> //
> // On Sat, 6 Feb 1999, Jonny Hinojosa wrote:
> //
> // select * from events
> // where event_id=(select max(event_id) from events);
> //
> // That works in my event database.
> //
> // // SET QUERY_LIMIT TO restricts the number of rows returned. I want to
> // // determine the largest value in a column. Sorry if my question was
> // unclear,
> // // I am new to %SQL.
> // //
> // // Jonny
> // //
> // // -----Original Message-----
> // // From: Neil Burrows [mailto:maillist(at)remo(dot)demon(dot)co(dot)uk]
> // // Sent: Saturday, February 06, 1999 1:51 PM
> // // To: Jonny Hinojosa
> // // Cc: psql-general(at)postgresql(dot)org
> // // Subject: RE: [GENERAL] No MAX function
> // //
> // //
> // // Hi,
> // //
> // // I believe there is a patch in "contrib" directory that does this, but if
> // you
> // // have Postgres 6.4 then have a look at the
> // //
> // // SET QUERY_LIMIT TO
> // //
> // // command.
> // //
> // // Regards,
> // //
> // // ---[ Neil
> // urrows ]-----------------------------------------------------
> // // E-mail: neil(at)pawprint(dot)co(dot)uk ** This e-mail was
> // **
> // // Web : http://www.remo.demon.co.uk/ ** Made in Scotland
> // **
> // // -------< PGP Key available from http://www.remo.demon.co.uk/pgp/
> // >--------
> // //
> // //
> // //
> // // > -----Original Message-----
> // // > From: owner-pgsql-general(at)postgreSQL(dot)org
> // // > [mailto:owner-pgsql-general(at)postgreSQL(dot)org]On Behalf Of Jonny Hinojosa
> // // > Sent: 06 February 1999 19:13
> // // > To: PostGreSQL Mailing List
> // // > Subject: [GENERAL] No MAX function
> // // >
> // // >
> // // > Does anyone have a work around for the lack of a MAX function ? I need
> // to
> // // > find the last record WHERE a LIKE 'x' AND b LIKE 'y'.
> // // >
> // // > Jonny Hinojosa
> // // > TCA Internet
> // // > Jonny(at)TCA(dot)net
> // // > 409.693.8885
> // // >
> // // >
> // //
> // //
> // //
> //
> // --
> // Principal Member Technical Staff, beyond.com The world is watching
> // America,
> // pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> // | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
> // L______________________________________________ and America is watching TV.
> // __
> //
> //
> //
>
> --
> Principal Member Technical Staff, beyond.com The world is watching America,
> pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
> L______________________________________________ and America is watching TV. __
>
>
>

Aleksei Roudnev, Network Operations Center, Relcom, Moscow
(+7 095) 194-19-95 (Network Operations Center Hot Line),(+7 095) 230-41-41, N 13729 (pager)
(+7 095) 196-72-12 (Support), (+7 095) 194-33-28 (Fax)