Re: Question on indexes

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(at)yahoo(dot)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
>