RE: [GENERAL] No MAX function

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 Burrows ]-----------------------------------------------------
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
>
>