Re: remove dups

Posted in 2000

Mark D. Stock — Wed, 28 Jun 2000 21:32:50 +0100 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > > From: "Jay Buckler" <buckler@sover.net> > > > >min() works just fine with char/varchar. Always has. > > > >"Mark D. Stock" <mdstock@mydas.freeserve.co.uk> wrote in message > >news:8j8kps$75b$1@news.xmission.com... > > > > > > pauleccleston@my-deja.com wrote: > > > > > > > > SELECT id, min(text) from table group by id> > > > > > Nice thought, but MIN requires (or at least always used to require) a > > > numeric argument. > > Indeed. I went back to 5.08, and it worked fine... :-) Well thanks for the effort, but I've been using MIN() since version 1, so I guess it didn't at some time. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+