RE: [GENERAL] No MAX function - Mailing list pgsql-general

From Jonny Hinojosa
Subject RE: [GENERAL] No MAX function
Date
Msg-id 000a01be5211$a1893cc0$03000004@Jonny.TCA.net
Whole thread Raw
In response to RE: [GENERAL] No MAX function  (dustin sallings <dustin@spy.net>)
Responses RE: [GENERAL] No MAX function
List pgsql-general
On v6.4.2, I get :

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=>

Jonny

-----Original Message-----
From: dustin sallings [mailto:dustin@spy.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@remo.demon.co.uk]
// Sent: Saturday, February 06, 1999 1:51 PM
// To: Jonny Hinojosa
// Cc: psql-general@postgresql.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@pawprint.co.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@postgreSQL.org
// > [mailto:owner-pgsql-general@postgreSQL.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@TCA.net
// > 409.693.8885
// >
// >
//
//
//

--
Principal Member Technical Staff, beyond.com    The world is watching
America,
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.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.
__


pgsql-general by date:

Previous
From: dustin sallings
Date:
Subject: RE: [GENERAL] No MAX function
Next
From: dustin sallings
Date:
Subject: RE: [GENERAL] No MAX function