Re: remove dups

Posted in 2000

Obnoxio The Clown — Wed, 28 Jun 2000 11:12:31 BST — source: Informix-list mailing list archive (1991-1998)

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... :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com