X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 0B8F09DC9B6
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Mon, 19 Dec 2005 12:29:12 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 74658-06
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Mon, 19 Dec 2005 12:29:11 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206])
	by postgresql.org (Postfix) with ESMTP id 5AAE39DC9C5
	for <pgsql-general@postgresql.org>;
	Mon, 19 Dec 2005 12:29:10 -0400 (AST)
Received: by zproxy.gmail.com with SMTP id 14so1967181nzn
	for <pgsql-general@postgresql.org>;
	Mon, 19 Dec 2005 08:29:09 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=OD0fAzB4FzdcSiAhwKNFesvka/1PpU88mzQKOIfTSqoPu5oDkiZvxxNzUBq99iJI5f/oCoeW1WsA+IfgG9VOXqTogkfy/b4ayPNBww4rMxwj9hSQnkD5Ov+fU6enVaFd4YlaJSQatQqwRzw1QFOE/tNDc7qLpigzSL0KKxtOWQI=
Received: by 10.65.194.2 with SMTP id w2mr3148135qbp;
	Mon, 19 Dec 2005 08:29:09 -0800 (PST)
Received: by 10.65.81.4 with HTTP; Mon, 19 Dec 2005 08:29:09 -0800 (PST)
Message-ID: <3e74dc250512190829o512abb49g7f5cb3b73841b64f@mail.gmail.com>
Date: Mon, 19 Dec 2005 08:29:09 -0800
From: vishal saberwal <vishalsaberwal@gmail.com>
To: Emil Rachovsky <zsevgymko@yahoo.com>
Subject: Re: Question on indexes
Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
In-Reply-To: <20051219155158.45162.qmail@web54312.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_34862_1645882.1135009749134"
References: <20051219155158.45162.qmail@web54312.mail.yahoo.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.071 required=5 tests=[AWL=0.070,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.071
X-Spam-Level: 
X-Archive-Number: 200512/953
X-Sequence-Number: 88516

------=_Part_34862_1645882.1135009749134
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

CREATE INDEX code_idx ON films(code) TABLESPACE indexspace;

http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html

vish

On 12/19/05, Emil Rachovsky <zsevgymko@yahoo.com> wrote:
>
>
> Hi,
> Can anyone show me a simple way of creating an index
> in PostGre like that:
> create index indName on someTable(someIntColumn DESC)
> ?
>
> Thanks In Advance,
> Emil
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

------=_Part_34862_1645882.1135009749134
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<pre>CREATE INDEX code_idx ON films(code) TABLESPACE indexspace;</pre><a hr=
ef=3D"http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html" =
target=3D"_blank" onclick=3D"return top.js.OpenExtLink(window,event,this)">=
http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html
</a><br><br>vish<br><br><div><span class=3D"gmail_quote">On 12/19/05, <b cl=
ass=3D"gmail_sendername">Emil Rachovsky</b> &lt;<a href=3D"mailto:zsevgymko=
@yahoo.com">zsevgymko@yahoo.com</a>&gt; wrote:</span><blockquote class=3D"g=
mail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Hi,<br>Can anyone show me a simple way of creating an index<br>in PostG=
re like that:<br>create index indName on someTable(someIntColumn DESC)<br>?=
<br><br>Thanks In Advance,<br>Emil<br><br>_________________________________=
_________________
<br>Do You Yahoo!?<br>Tired of spam?&nbsp;&nbsp;Yahoo! Mail has the best sp=
am protection around<br><a href=3D"http://mail.yahoo.com">http://mail.yahoo=
.com</a><br><br>---------------------------(end of broadcast)--------------=
-------------
<br>TIP 3: Have you checked our extensive FAQ?<br><br>&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=3D"=
http://www.postgresql.org/docs/faq">http://www.postgresql.org/docs/faq</a><=
br></blockquote></div><br>

------=_Part_34862_1645882.1135009749134--