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 CFD539DC9AC for ; Mon, 19 Dec 2005 11:52:02 -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 66043-04 for ; Mon, 19 Dec 2005 11:52:04 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54312.mail.yahoo.com (web54312.mail.yahoo.com [206.190.49.122]) by postgresql.org (Postfix) with SMTP id 82AD89DC80C for ; Mon, 19 Dec 2005 11:51:57 -0400 (AST) Received: (qmail 45164 invoked by uid 60001); 19 Dec 2005 15:51:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CG+aegSmkXL4ygIrduuuFhFspDn2Z4/bR3F6j0V6vpIaS4usakzczj4IF3niPXKlJP/75mmtfokk1BuKsejWZ06Zs6SJBV8wVEmdqSmm4k3skp6TtRE99j3ve0PY2TawxY1Rm4GOEg8MnvVlgtYldG5lZzg7UZG4aDgULW+ELAI= ; Message-ID: <20051219155158.45162.qmail@web54312.mail.yahoo.com> Received: from [213.91.244.26] by web54312.mail.yahoo.com via HTTP; Mon, 19 Dec 2005 07:51:58 PST Date: Mon, 19 Dec 2005 07:51:58 -0800 (PST) From: Emil Rachovsky Subject: Question on indexes To: pgsql-sql@postgresql.org Cc: pgsql-general@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.368 required=5 tests=[AWL=-0.111, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.368 X-Spam-Level: X-Archive-Number: 200512/951 X-Sequence-Number: 88514 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