Re: question about numbering of rows?

Dear Ken

I just tried this out.

psql test
{return prompts}
\! tcl query

And it does work. No need to change over to tcl. Just get little bit of help
when convenient.

Vijay

Ken Corey wrote:

> On Tuesday 13 March 2001 3:56 pm, you wrote:
> > Have you missed one and after "make=2" ?
>
> Hi Vijay...yes, of course, you're right. I'd like to say it's a 'cut and
> paste' error and blame the computer...but I'm afraid I typed it in by hand.
>
> (The question still stands, though...)
>
> >
> > Vijay
> >
> > Ken Corey wrote:
> > > I have a table like this:
> > >
> > > id | make | model | year | value
> > > ---------+-----------+--------+-------+-------
> > > 57 | 2 | 0 | 4 | 4750
> > > 57 | 2 | 3 | 4 | 4750
> > > I want to be able to select from this table like this:
> > > select
> > > <numbering magic>, id, value
> > > from
> > > mytable
> > > where
> > > make=2
> > > model=3
> > > and year=5
> > > order by score desc;
>
> --
> Ken Corey, CTO Atomic Interactive, Ltd. ken(dot)corey(at)atomic-interactive(dot)com