RE: [GENERAL] No MAX function

1999-02-08 Thread Alex P. Rudnev
s <[EMAIL PROTECTED]> > To: Jonny Hinojosa <[EMAIL PROTECTED]> > Cc: PostGreSQL Mailing List <[EMAIL PROTECTED]> > Subject: RE: [GENERAL] No MAX function > > On Sat, 6 Feb 1999, Jonny Hinojosa wrote: > > // cdmwhere=> SELECT * FROM traplog WHERE millisid=

RE: [GENERAL] No MAX function

1999-02-06 Thread dustin sallings
Hinojosa // // Cc: [EMAIL PROTECTED] // // 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 // // // // comman

RE: [GENERAL] No MAX function

1999-02-06 Thread Jonny Hinojosa
Message- From: dustin sallings [mailto:[EMAIL PROTECTED]] 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) f

RE: [GENERAL] No MAX function

1999-02-06 Thread dustin sallings
question was unclear, // I am new to %SQL. // // Jonny // // -Original Message- // From: Neil Burrows [mailto:[EMAIL PROTECTED]] // Sent: Saturday, February 06, 1999 1:51 PM // To: Jonny Hinojosa // Cc: [EMAIL PROTECTED] // Subject: RE: [GENERAL] No MAX function // // // Hi, // // I

RE: [GENERAL] No MAX function

1999-02-06 Thread Jonny Hinojosa
Hinojosa Cc: [EMAIL PROTECTED] 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, ---[ Ne

[GENERAL] No MAX function

1999-02-06 Thread Jonny Hinojosa
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 [EMAIL PROTECTED] 409.693.8885