Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id AE4F81337B49 for ; Sat, 2 Oct 2010 10:42:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 68395-05 for ; Sat, 2 Oct 2010 13:42:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com [209.85.216.181]) by mail.postgresql.org (Postfix) with ESMTP id 775441337B80 for ; Sat, 2 Oct 2010 10:42:48 -0300 (ADT) Received: by qyk9 with SMTP id 9so2327282qyk.19 for ; Sat, 02 Oct 2010 06:42:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :x-enigmail-version:content-type:content-transfer-encoding; bh=Od0tiEkEKHiDFerR+rct3/1Aavhv1sizoFFehQD4Cug=; b=rEamszRxAtrRAoVPdK24zI/X9LPYBkJ6eBkQhAjQ7S+eFgbc/qpe8QqaIBKM7wgQk4 5RVSPersCTYfu9OTW+smTc2bPCLkA2+FM/tlOLNiQNZIBEun4zavYcPHKG4of33ipdj/ phGtyk49esRn3bvEpPCFyvUwikBri8F7OSE3g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; b=U7mxyhV3svSBOyMh/NLg9v7D9yxkzDKW0b2WQIawQq/BYu58YceXGdzNXfDIoYZCTn eFR2Q/4TSGXndCBpVxibUL3VafkX6QWViUgF0UPldtE09TerEk+RdXaG3NtdNaBR27BV +xO9j5XT7nq7yCeq0TybYF2b7MG3Hs793nJJI= Received: by 10.229.98.84 with SMTP id p20mr5012635qcn.149.1286026968249; Sat, 02 Oct 2010 06:42:48 -0700 (PDT) Received: from [192.168.1.100] (207-237-122-16.c3-0.wsd-ubr1.qens-wsd.ny.cable.rcn.com [207.237.122.16]) by mx.google.com with ESMTPS id f15sm2688244qcr.1.2010.10.02.06.42.46 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 02 Oct 2010 06:42:47 -0700 (PDT) Message-ID: <4CA736C5.5080606@gmail.com> Date: Sat, 02 Oct 2010 09:42:29 -0400 From: Lee Hachadoorian User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.12) Gecko/20100915 Thunderbird/3.0.8 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Random sort with distinct References: <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com> In-Reply-To: <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com> X-Enigmail-Version: 1.0.1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.176 tagged_above=-5 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, MIME_HTML_ONLY=0.723, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/4 X-Sequence-Number: 34655 This runs fine on my 8.4 install. What version are you using and what error message are you getting?

--Lee

On 10/01/2010 04:51 PM, Ozer, Pam wrote:

I have the following query

Select Distinct VehicleMake, VehicleModel

From VehicleYearMakeModelTrim

Order by random()

Limit 10;

I don’t want to bring back the random number I just want the sort order to be random. How can I sort randomly? This query breaks because random() is not in the select.

Thanks

Pam

-- 
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center