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.corey@atomic-interactive.com