Re: [SQL] distinct values without seq scan

2004-04-07 Thread Josh Berkus
Bret, > I have a table indexed on a char(35) field and want a query to return a > distinct list of the values in this column. Is there some syntactical > magic I can do to get these values without a sequential scan? I assume, > ( here we go again ) that these values are in the index somewhere an

[SQL] distinct values without seq scan

2004-04-06 Thread Bret Hughes
I have a table indexed on a char(35) field and want a query to return a distinct list of the values in this column. Is there some syntactical magic I can do to get these values without a sequential scan? I assume, ( here we go again ) that these values are in the index somewhere and I seem to rec