From pozer@automotive.com Fri Oct  1 20:53:01 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id DA887133729E
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri,  1 Oct 2010 17:53:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 71775-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri,  1 Oct 2010 20:52:54 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail1.automotive.com (mail1.automotive.com [12.131.237.150])
	by mail.postgresql.org (Postfix) with ESMTP id 0D9E01337B6D
	for <pgsql-sql@postgresql.org>; Fri,  1 Oct 2010 17:52:53 -0300 (ADT)
Received: from mail1.automotive.com ([10.0.0.23]) by mail1.automotive.com with
	Microsoft SMTPSVC(6.0.3790.4675); Fri, 1 Oct 2010 13:52:44 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CB61AA.7129CDC8"
Subject: Random sort with distinct
Date: Fri, 1 Oct 2010 13:51:38 -0700
Message-ID: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Random sort with distinct
Thread-Index: Acthqm/ZKCMbWz0HTEepSOy+a+W1tg==
From: "Ozer, Pam" <pozer@automotive.com>
To: <pgsql-sql@postgresql.org>
X-OriginalArrivalTime: 01 Oct 2010 20:52:44.0783 (UTC)
	FILETIME=[98E76FF0:01CB61AA]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.509 tagged_above=-5 required=5 tests=BAYES_05=-0.5,
	HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201010/2
X-Sequence-Number: 34653

This is a multi-part message in MIME format.

------_=_NextPart_001_01CB61AA.7129CDC8
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have the following query

=20

Select Distinct VehicleMake, VehicleModel

>From VehicleYearMakeModelTrim

Order by random()

Limit 10;

=20

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.

=20

Thanks

=20

Pam






------_=_NextPart_001_01CB61AA.7129CDC8
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spreadsheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"=
 xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile" =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsig-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsig" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/2006/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types"=
 =
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPortalServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{mso-style-priority:99;
	mso-style-link:"Balloon Text Char";
	margin:0in;
	margin-bottom:.0001pt;
	font-size:8.0pt;
	font-family:"Tahoma","sans-serif";}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.BalloonTextChar
	{mso-style-name:"Balloon Text Char";
	mso-style-priority:99;
	mso-style-link:"Balloon Text";
	font-family:"Tahoma","sans-serif";}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DWordSection1>

<p class=3DMsoNormal>I have the following query<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Select Distinct VehicleMake, =
VehicleModel<o:p></o:p></p>

<p class=3DMsoNormal>From VehicleYearMakeModelTrim<o:p></o:p></p>

<p class=3DMsoNormal>Order by random()<o:p></o:p></p>

<p class=3DMsoNormal>Limit 10;<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>I don&#8217;t want to bring back the random number =
I just
want the sort order to be random. How can I sort randomly?&nbsp; This =
query breaks
because random() is not in the select.<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Thanks<o:p></o:p></p>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>Pam<o:p></o:p></p>

<p class=3DMsoNormal><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'><br>
<br>
</span><o:p></o:p></p>

</div>

</body>

</html>

------_=_NextPart_001_01CB61AA.7129CDC8--



From dmitigr@gmail.com Sat Oct  2 13:40:24 2010
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 4D0BB1337B50
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  2 Oct 2010 10:40:24 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 12979-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  2 Oct 2010 13:40:17 +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 2180A1337B49
	for <pgsql-sql@postgresql.org>; Sat,  2 Oct 2010 10:40:15 -0300 (ADT)
Received: by qyk9 with SMTP id 9so2325176qyk.19
	for <pgsql-sql@postgresql.org>; Sat, 02 Oct 2010 06:40:15 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=fRt1tYanTbYqLBnZyMC0mbEnmKpP5Vl8AlhOw1O9bGc=;
	b=ONqgwKaLU3KnnHtHjCnCf4xwzN9N9mFitPxrgKL7lcFXugHdkR9GBqkT6yJQCGi5Pl
	jOCPGUMzsyNXIx5sSZCtmYmpMD9+v44D+v8k9tVshyQdRz75daUNliQOnSgn+Skzllnm
	285sqi5eQtrvCcHBpc2r5pbUA0ma+ywOq+9AU=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=QIW/yYh+nVcwwSASaStZJHxYBrAzDj0uwcNHpZ5ZEffqMQKh1ZdlUuogSkxH8IRbbJ
	Q5vh9kDrCrjM6Qz0KQjPKafStK7teMxojKvqDOlx284aj2/k9wwsbDpezJaYhl2sOt2A
	HwzugK0mwA8SUcdV2woKBoeVZBpXYhMxIX/hw=
MIME-Version: 1.0
Received: by 10.224.54.13 with SMTP id o13mr4950233qag.9.1286026815393; Sat,
	02 Oct 2010 06:40:15 -0700 (PDT)
Received: by 10.229.219.201 with HTTP; Sat, 2 Oct 2010 06:40:15 -0700 (PDT)
In-Reply-To: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com>
References: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com>
Date: Sat, 2 Oct 2010 17:40:15 +0400
Message-ID: <AANLkTimJi+TfKsuenpKcThuNfPpTrhW6j1kBXV1QsKzG@mail.gmail.com>
Subject: Re: Random sort with distinct
From: Dmitriy Igrishin <dmitigr@gmail.com>
To: "Ozer, Pam" <pozer@automotive.com>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=0015175cf80a80d0720491a2739c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201010/3
X-Sequence-Number: 34654

--0015175cf80a80d0720491a2739c
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hey Ozer,

How about dynamic queries?

2010/10/2 Ozer, Pam <pozer@automotive.com>

>  I have the following query
>
>
>
> Select Distinct VehicleMake, VehicleModel
>
> From VehicleYearMakeModelTrim
>
> Order by random()
>
> Limit 10;
>
>
>
> I don=E2=80=99t 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() i=
s
> not in the select.
>
>
>
> Thanks
>
>
>
> Pam
>
>
>
>


--=20
// Dmitriy.

--0015175cf80a80d0720491a2739c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hey Ozer,<br><br>How about dynamic queries?<br><br><div class=3D"gmail_quot=
e">2010/10/2 Ozer, Pam <span dir=3D"ltr">&lt;<a href=3D"mailto:pozer@automo=
tive.com">pozer@automotive.com</a>&gt;</span><br><blockquote class=3D"gmail=
_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204,=
 204, 204); padding-left: 1ex;">









<div link=3D"blue" vlink=3D"purple" lang=3D"EN-US">

<div>

<p class=3D"MsoNormal">I have the following query</p>

<p class=3D"MsoNormal">=C2=A0</p>

<p class=3D"MsoNormal">Select Distinct VehicleMake, VehicleModel</p>

<p class=3D"MsoNormal">From VehicleYearMakeModelTrim</p>

<p class=3D"MsoNormal">Order by random()</p>

<p class=3D"MsoNormal">Limit 10;</p>

<p class=3D"MsoNormal">=C2=A0</p>

<p class=3D"MsoNormal">I don=E2=80=99t want to bring back the random number=
 I just
want the sort order to be random. How can I sort randomly?=C2=A0 This query=
 breaks
because random() is not in the select.</p>

<p class=3D"MsoNormal">=C2=A0</p>

<p class=3D"MsoNormal">Thanks</p>

<p class=3D"MsoNormal">=C2=A0</p>

<p class=3D"MsoNormal">Pam</p>

<p class=3D"MsoNormal"><span style=3D"font-size: 12pt; font-family: &quot;T=
imes New Roman&quot;,&quot;serif&quot;;"><br>
<br>
</span></p>

</div>

</div>


</blockquote></div><br><br clear=3D"all"><br>-- <br>// Dmitriy.<br><br><br>

--0015175cf80a80d0720491a2739c--



From lee.hachadoorian@gmail.com Sat Oct  2 13:42:55 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id AE4F81337B49
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; Sat,  2 Oct 2010 10:42:48 -0300 (ADT)
Received: by qyk9 with SMTP id 9so2327282qyk.19
	for <pgsql-sql@postgresql.org>; 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 <lee.hachadoorian@gmail.com>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
This runs fine on my 8.4 install. What version are you using and what
error message are you getting?<br>
<br>
--Lee<br>
<br>
On 10/01/2010 04:51 PM, Ozer, Pam wrote:
<blockquote
 cite="mid:216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com"
 type="cite">
  <meta http-equiv="Content-Type"
 content="text/html; charset=ISO-8859-1">
  <meta name="Generator" content="Microsoft Word 12 (filtered medium)">
  <style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{mso-style-priority:99;
	mso-style-link:"Balloon Text Char";
	margin:0in;
	margin-bottom:.0001pt;
	font-size:8.0pt;
	font-family:"Tahoma","sans-serif";}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri","sans-serif";
	color:windowtext;}
span.BalloonTextChar
	{mso-style-name:"Balloon Text Char";
	mso-style-priority:99;
	mso-style-link:"Balloon Text";
	font-family:"Tahoma","sans-serif";}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
-->
  </style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->
  <div class="WordSection1">
  <p class="MsoNormal">I have the following query<o:p></o:p></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  <p class="MsoNormal">Select Distinct VehicleMake, VehicleModel<o:p></o:p></p>
  <p class="MsoNormal">From VehicleYearMakeModelTrim<o:p></o:p></p>
  <p class="MsoNormal">Order by random()<o:p></o:p></p>
  <p class="MsoNormal">Limit 10;<o:p></o:p></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  <p class="MsoNormal">I don&#8217;t want to bring back the random number I
just
want the sort order to be random. How can I sort randomly?&nbsp; This query
breaks
because random() is not in the select.<o:p></o:p></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  <p class="MsoNormal">Thanks<o:p></o:p></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  <p class="MsoNormal">Pam<o:p></o:p></p>
  <p class="MsoNormal"><span
 style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"><br>
  <br>
  </span><o:p></o:p></p>
  </div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 
Lee Hachadoorian
PhD Student, Geography
Program in Earth &amp; Environmental Sciences
CUNY Graduate Center
</pre>
</body>
</html>



From tgl@sss.pgh.pa.us Sat Oct  2 13:52:57 2010
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id C674813364DE
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  2 Oct 2010 10:52:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 61971-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat,  2 Oct 2010 13:52:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id A71161335B36
	for <pgsql-sql@postgresql.org>; Sat,  2 Oct 2010 10:52:50 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o92DqoKZ005071;
	Sat, 2 Oct 2010 09:52:50 -0400 (EDT)
To: "Ozer, Pam" <pozer@automotive.com>
cc: pgsql-sql@postgresql.org
Subject: Re: Random sort with distinct 
In-reply-to: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com>
References: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com>
Comments: In-reply-to "Ozer, Pam" <pozer@automotive.com>
	message dated "Fri, 01 Oct 2010 13:51:38 -0700"
Date: Sat, 02 Oct 2010 09:52:50 -0400
Message-ID: <5070.1286027570@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201010/5
X-Sequence-Number: 34656

"Ozer, Pam" <pozer@automotive.com> writes:
> 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.

Well, yeah: the implication of the ORDER BY is that a new random value
is to be computed for each row of VehicleYearMakeModelTrim.  After you
combine rows with DISTINCT it's not clear which of those values should
be used to sort a grouped row.

You need to put the DISTINCT and the ORDER BY in separate query levels,
like this:

select * from
  (Select Distinct VehicleMake, VehicleModel
   From VehicleYearMakeModelTrim) ss
Order by random()
Limit 10;

			regards, tom lane



From pozer@automotive.com Mon Oct  4 15:40:54 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id EC2FB1337B77
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  4 Oct 2010 12:40:54 -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 32922-05 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  4 Oct 2010 15:40:47 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail1.automotive.com (mail1.automotive.com [12.131.237.150])
	by mail.postgresql.org (Postfix) with ESMTP id 629341337B6C
	for <pgsql-sql@postgresql.org>; Mon,  4 Oct 2010 12:40:46 -0300 (ADT)
Received: from mail1.automotive.com ([10.0.0.23]) by mail1.automotive.com with
	Microsoft SMTPSVC(6.0.3790.4675); Mon, 4 Oct 2010 08:40:42 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CB63DA.81997712"
Subject: Re: Random sort with distinct
Date: Mon, 4 Oct 2010 08:40:43 -0700
Message-ID: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182D0@mail-001.corp.automotive.com>
In-Reply-To: <AANLkTimJi+TfKsuenpKcThuNfPpTrhW6j1kBXV1QsKzG@mail.gmail.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [SQL] Random sort with distinct
Thread-Index: ActiUVINwVWCvIT9SbGsjzJvjLLKsABiSlqA
References: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D10182C8@mail-001.corp.automotive.com>
	<AANLkTimJi+TfKsuenpKcThuNfPpTrhW6j1kBXV1QsKzG@mail.gmail.com>
From: "Ozer, Pam" <pozer@automotive.com>
To: "Dmitriy Igrishin" <dmitigr@gmail.com>
Cc: <pgsql-sql@postgresql.org>
X-OriginalArrivalTime: 04 Oct 2010 15:40:42.0236 (UTC)
	FILETIME=[80A2BBC0:01CB63DA]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201010/14
X-Sequence-Number: 34665

This is a multi-part message in MIME format.

------_=_NextPart_001_01CB63DA.81997712
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: base64

V2hhdCBhYm91dCBkeW5hbWljIHF1ZXJpZXM/DQoNCiANCg0KRnJvbTogcGdzcWwtc3FsLW93bmVy
QHBvc3RncmVzcWwub3JnIFttYWlsdG86cGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwub3JnXSBP
biBCZWhhbGYgT2YgRG1pdHJpeSBJZ3Jpc2hpbg0KU2VudDogU2F0dXJkYXksIE9jdG9iZXIgMDIs
IDIwMTAgNjo0MCBBTQ0KVG86IE96ZXIsIFBhbQ0KQ2M6IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9y
Zw0KU3ViamVjdDogUmU6IFtTUUxdIFJhbmRvbSBzb3J0IHdpdGggZGlzdGluY3QNCg0KIA0KDQpI
ZXkgT3plciwNCg0KSG93IGFib3V0IGR5bmFtaWMgcXVlcmllcz8NCg0KMjAxMC8xMC8yIE96ZXIs
IFBhbSA8cG96ZXJAYXV0b21vdGl2ZS5jb20+DQoNCkkgaGF2ZSB0aGUgZm9sbG93aW5nIHF1ZXJ5
DQoNCiANCg0KU2VsZWN0IERpc3RpbmN0IFZlaGljbGVNYWtlLCBWZWhpY2xlTW9kZWwNCg0KRnJv
bSBWZWhpY2xlWWVhck1ha2VNb2RlbFRyaW0NCg0KT3JkZXIgYnkgcmFuZG9tKCkNCg0KTGltaXQg
MTA7DQoNCiANCg0KSSBkb27igJl0IHdhbnQgdG8gYnJpbmcgYmFjayB0aGUgcmFuZG9tIG51bWJl
ciBJIGp1c3Qgd2FudCB0aGUgc29ydCBvcmRlciB0byBiZSByYW5kb20uIEhvdyBjYW4gSSBzb3J0
IHJhbmRvbWx5PyAgVGhpcyBxdWVyeSBicmVha3MgYmVjYXVzZSByYW5kb20oKSBpcyBub3QgaW4g
dGhlIHNlbGVjdC4NCg0KIA0KDQpUaGFua3MNCg0KIA0KDQpQYW0NCg0KIA0KDQoNCg0KDQotLSAN
Ci8vIERtaXRyaXkuDQoNCg0KDQo=

------_=_NextPart_001_01CB63DA.81997712
Content-Type: text/html;
	charset="UTF-8"
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9z
b2Z0LWNvbTpvZmZpY2U6ZXhjZWwiIHhtbG5zOnA9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206
b2ZmaWNlOnBvd2VycG9pbnQiIHhtbG5zOmE9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2Zm
aWNlOmFjY2VzcyIgeG1sbnM6ZHQ9InV1aWQ6QzJGNDEwMTAtNjVCMy0xMWQxLUEyOUYtMDBBQTAw
QzE0ODgyIiB4bWxuczpzPSJ1dWlkOkJEQzZFM0YwLTZEQTMtMTFkMS1BMkEzLTAwQUEwMEMxNDg4
MiIgeG1sbnM6cnM9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206cm93c2V0IiB4bWxuczp6PSIj
Um93c2V0U2NoZW1hIiB4bWxuczpiPSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTpw
dWJsaXNoZXIiIHhtbG5zOnNzPSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTpzcHJl
YWRzaGVldCIgeG1sbnM6Yz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6Y29tcG9u
ZW50OnNwcmVhZHNoZWV0IiB4bWxuczpvZGM9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2Zm
aWNlOm9kYyIgeG1sbnM6b2E9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOmFjdGl2
YXRpb24iIHhtbG5zOmh0bWw9Imh0dHA6Ly93d3cudzMub3JnL1RSL1JFQy1odG1sNDAiIHhtbG5z
OnE9Imh0dHA6Ly9zY2hlbWFzLnhtbHNvYXAub3JnL3NvYXAvZW52ZWxvcGUvIiB4bWxuczpydGM9
Imh0dHA6Ly9taWNyb3NvZnQuY29tL29mZmljZW5ldC9jb25mZXJlbmNpbmciIHhtbG5zOkQ9IkRB
VjoiIHhtbG5zOlJlcGw9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vcmVwbC8iIHhtbG5z
Om10PSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3NoYXJlcG9pbnQvc29hcC9tZWV0aW5n
cy8iIHhtbG5zOngyPSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS9leGNlbC8y
MDAzL3htbCIgeG1sbnM6cHBkYT0iaHR0cDovL3d3dy5wYXNzcG9ydC5jb20vTmFtZVNwYWNlLnhz
ZCIgeG1sbnM6b2lzPSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3NoYXJlcG9pbnQvc29h
cC9vaXMvIiB4bWxuczpkaXI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vc2hhcmVwb2lu
dC9zb2FwL2RpcmVjdG9yeS8iIHhtbG5zOmRzPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwLzA5L3ht
bGRzaWcjIiB4bWxuczpkc3A9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vc2hhcmVwb2lu
dC9kc3AiIHhtbG5zOnVkYz0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9kYXRhL3VkYyIg
eG1sbnM6eHNkPSJodHRwOi8vd3d3LnczLm9yZy8yMDAxL1hNTFNjaGVtYSIgeG1sbnM6c3ViPSJo
dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3NoYXJlcG9pbnQvc29hcC8yMDAyLzEvYWxlcnRz
LyIgeG1sbnM6ZWM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDEvMDQveG1sZW5jIyIgeG1sbnM6c3A9
Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vc2hhcmVwb2ludC8iIHhtbG5zOnNwcz0iaHR0
cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9zaGFyZXBvaW50L3NvYXAvIiB4bWxuczp4c2k9Imh0
dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3RhbmNlIiB4bWxuczp1ZGNzPSJodHRw
Oi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2RhdGEvdWRjL3NvYXAiIHhtbG5zOnVkY3hmPSJodHRw
Oi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2RhdGEvdWRjL3htbGZpbGUiIHhtbG5zOnVkY3AycD0i
aHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9kYXRhL3VkYy9wYXJ0dG9wYXJ0IiB4bWxuczp3
Zj0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9zaGFyZXBvaW50L3NvYXAvd29ya2Zsb3cv
IiB4bWxuczpkc3NzPSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS8yMDA2L2Rp
Z3NpZy1zZXR1cCIgeG1sbnM6ZHNzaT0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9vZmZp
Y2UvMjAwNi9kaWdzaWciIHhtbG5zOm1kc3NpPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0
cy5vcmcvcGFja2FnZS8yMDA2L2RpZ2l0YWwtc2lnbmF0dXJlIiB4bWxuczptdmVyPSJodHRwOi8v
c2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcvbWFya3VwLWNvbXBhdGliaWxpdHkvMjAwNiIgeG1s
bnM6bT0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4
bWxuczptcmVscz0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL3BhY2thZ2UvMjAw
Ni9yZWxhdGlvbnNoaXBzIiB4bWxuczpzcHdwPSJodHRwOi8vbWljcm9zb2Z0LmNvbS9zaGFyZXBv
aW50L3dlYnBhcnRwYWdlcyIgeG1sbnM6ZXgxMnQ9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5j
b20vZXhjaGFuZ2Uvc2VydmljZXMvMjAwNi90eXBlcyIgeG1sbnM6ZXgxMm09Imh0dHA6Ly9zY2hl
bWFzLm1pY3Jvc29mdC5jb20vZXhjaGFuZ2Uvc2VydmljZXMvMjAwNi9tZXNzYWdlcyIgeG1sbnM6
cHB0c2w9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vc2hhcmVwb2ludC9zb2FwL1NsaWRl
TGlicmFyeS8iIHhtbG5zOnNwc2w9Imh0dHA6Ly9taWNyb3NvZnQuY29tL3dlYnNlcnZpY2VzL1No
YXJlUG9pbnRQb3J0YWxTZXJ2ZXIvUHVibGlzaGVkTGlua3NTZXJ2aWNlIiB4bWxuczpaPSJ1cm46
c2NoZW1hcy1taWNyb3NvZnQtY29tOiIgeG1sbnM6c3Q9IiYjMTsiIHhtbG5zPSJodHRwOi8vd3d3
LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCg0KPGhlYWQ+DQo8bWV0YSBodHRwLWVxdWl2PUNvbnRl
bnQtVHlwZSBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1ldGEgbmFtZT1H
ZW5lcmF0b3IgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTIgKGZpbHRlcmVkIG1lZGl1bSkiPg0K
PHN0eWxlPg0KPCEtLQ0KIC8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCiBAZm9udC1mYWNlDQoJe2Zv
bnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAyIDQ7fQ0KQGZv
bnQtZmFjZQ0KCXtmb250LWZhbWlseTpUYWhvbWE7DQoJcGFub3NlLTE6MiAxMSA2IDQgMyA1IDQg
NCAyIDQ7fQ0KIC8qIFN0eWxlIERlZmluaXRpb25zICovDQogcC5Nc29Ob3JtYWwsIGxpLk1zb05v
cm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFw
dDsNCglmb250LXNpemU6MTIuMHB0Ow0KCWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLCJz
ZXJpZiI7fQ0KYTpsaW5rLCBzcGFuLk1zb0h5cGVybGluaw0KCXttc28tc3R5bGUtcHJpb3JpdHk6
OTk7DQoJY29sb3I6Ymx1ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCmE6dmlzaXRl
ZCwgc3Bhbi5Nc29IeXBlcmxpbmtGb2xsb3dlZA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJ
Y29sb3I6cHVycGxlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0Kc3Bhbi5FbWFpbFN0
eWxlMTcNCgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtcmVwbHk7DQoJZm9udC1mYW1pbHk6IkNh
bGlicmkiLCJzYW5zLXNlcmlmIjsNCgljb2xvcjojMUY0OTdEO30NCi5Nc29DaHBEZWZhdWx0DQoJ
e21zby1zdHlsZS10eXBlOmV4cG9ydC1vbmx5O30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXpl
OjguNWluIDExLjBpbjsNCgltYXJnaW46MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2Lldv
cmRTZWN0aW9uMQ0KCXtwYWdlOldvcmRTZWN0aW9uMTt9DQotLT4NCjwvc3R5bGU+DQo8IS0tW2lm
IGd0ZSBtc28gOV0+PHhtbD4NCiA8bzpzaGFwZWRlZmF1bHRzIHY6ZXh0PSJlZGl0IiBzcGlkbWF4
PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQog
PG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPg0KICA8bzppZG1hcCB2OmV4dD0iZWRpdCIgZGF0
YT0iMSIgLz4NCiA8L286c2hhcGVsYXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQoN
Cjxib2R5IGxhbmc9RU4tVVMgbGluaz1ibHVlIHZsaW5rPXB1cnBsZT4NCg0KPGRpdiBjbGFzcz1X
b3JkU2VjdGlvbjE+DQoNCjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBzdHlsZT0nZm9udC1zaXpl
OjExLjBwdDtmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiOw0KY29sb3I6IzFGNDk3
RCc+V2hhdCBhYm91dCBkeW5hbWljIHF1ZXJpZXM/PG86cD48L286cD48L3NwYW4+PC9wPg0KDQo8
cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1p
bHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjsNCmNvbG9yOiMxRjQ5N0QnPjxvOnA+Jm5ic3A7PC9v
OnA+PC9zcGFuPjwvcD4NCg0KPGRpdiBzdHlsZT0nYm9yZGVyOm5vbmU7Ym9yZGVyLXRvcDpzb2xp
ZCAjQjVDNERGIDEuMHB0O3BhZGRpbmc6My4wcHQgMGluIDBpbiAwaW4nPg0KDQo8cCBjbGFzcz1N
c29Ob3JtYWw+PGI+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMC4wcHQ7Zm9udC1mYW1pbHk6IlRh
aG9tYSIsInNhbnMtc2VyaWYiJz5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4NCnN0eWxlPSdmb250LXNp
emU6MTAuMHB0O2ZvbnQtZmFtaWx5OiJUYWhvbWEiLCJzYW5zLXNlcmlmIic+DQpwZ3NxbC1zcWwt
b3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5v
cmddIDxiPk9uDQpCZWhhbGYgT2YgPC9iPkRtaXRyaXkgSWdyaXNoaW48YnI+DQo8Yj5TZW50Ojwv
Yj4gU2F0dXJkYXksIE9jdG9iZXIgMDIsIDIwMTAgNjo0MCBBTTxicj4NCjxiPlRvOjwvYj4gT3pl
ciwgUGFtPGJyPg0KPGI+Q2M6PC9iPiBwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmc8YnI+DQo8Yj5T
dWJqZWN0OjwvYj4gUmU6IFtTUUxdIFJhbmRvbSBzb3J0IHdpdGggZGlzdGluY3Q8bzpwPjwvbzpw
Pjwvc3Bhbj48L3A+DQoNCjwvZGl2Pg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWw+PG86cD4mbmJzcDs8
L286cD48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbWFyZ2luLWJvdHRvbToxMi4w
cHQnPkhleSBPemVyLDxicj4NCjxicj4NCkhvdyBhYm91dCBkeW5hbWljIHF1ZXJpZXM/PG86cD48
L286cD48L3A+DQoNCjxkaXY+DQoNCjxwIGNsYXNzPU1zb05vcm1hbD4yMDEwLzEwLzIgT3plciwg
UGFtICZsdDs8YSBocmVmPSJtYWlsdG86cG96ZXJAYXV0b21vdGl2ZS5jb20iPnBvemVyQGF1dG9t
b3RpdmUuY29tPC9hPiZndDs8bzpwPjwvbzpwPjwvcD4NCg0KPGRpdj4NCg0KPGRpdj4NCg0KPHAg
Y2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2lu
LWJvdHRvbS1hbHQ6YXV0byc+SQ0KaGF2ZSB0aGUgZm9sbG93aW5nIHF1ZXJ5PG86cD48L286cD48
L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87
bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8nPiZuYnNwOzxvOnA+PC9vOnA+PC9wPg0KDQo8cCBj
bGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21zby1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4t
Ym90dG9tLWFsdDphdXRvJz5TZWxlY3QNCkRpc3RpbmN0IFZlaGljbGVNYWtlLCBWZWhpY2xlTW9k
ZWw8bzpwPjwvbzpwPjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdtc28tbWFyZ2lu
LXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0byc+RnJvbQ0KVmVoaWNsZVll
YXJNYWtlTW9kZWxUcmltPG86cD48L286cD48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHls
ZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8nPk9y
ZGVyDQpieSByYW5kb20oKTxvOnA+PC9vOnA+PC9wPg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWwgc3R5
bGU9J21zby1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvJz5M
aW1pdA0KMTA7PG86cD48L286cD48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNv
LW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8nPiZuYnNwOzxv
OnA+PC9vOnA+PC9wPg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21zby1tYXJnaW4tdG9w
LWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvJz5JDQpkb27igJl0IHdhbnQgdG8g
YnJpbmcgYmFjayB0aGUgcmFuZG9tIG51bWJlciBJIGp1c3Qgd2FudCB0aGUgc29ydCBvcmRlciB0
byBiZQ0KcmFuZG9tLiBIb3cgY2FuIEkgc29ydCByYW5kb21seT8mbmJzcDsgVGhpcyBxdWVyeSBi
cmVha3MgYmVjYXVzZSByYW5kb20oKSBpcw0Kbm90IGluIHRoZSBzZWxlY3QuPG86cD48L286cD48
L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0nbXNvLW1hcmdpbi10b3AtYWx0OmF1dG87
bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8nPiZuYnNwOzxvOnA+PC9vOnA+PC9wPg0KDQo8cCBj
bGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21zby1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4t
Ym90dG9tLWFsdDphdXRvJz5UaGFua3M8bzpwPjwvbzpwPjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9y
bWFsIHN0eWxlPSdtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6
YXV0byc+Jm5ic3A7PG86cD48L286cD48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0n
bXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8nPlBhbTxv
OnA+PC9vOnA+PC9wPg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21zby1tYXJnaW4tdG9w
LWFsdDphdXRvO21hcmdpbi1ib3R0b206MTIuMHB0Jz48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCg0K
PC9kaXY+DQoNCjwvZGl2Pg0KDQo8L2Rpdj4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsIHN0eWxlPSdt
YXJnaW4tYm90dG9tOjEyLjBwdCc+PGJyPg0KPGJyIGNsZWFyPWFsbD4NCjxicj4NCi0tIDxicj4N
Ci8vIERtaXRyaXkuPGJyPg0KPGJyPg0KPG86cD48L286cD48L3A+DQoNCjwvZGl2Pg0KDQo8L2Jv
ZHk+DQoNCjwvaHRtbD4NCg==

------_=_NextPart_001_01CB63DA.81997712--