Re: How to do? - Mailing list pgsql-general

From Ron Johnson
Subject Re: How to do?
Date
Msg-id 1059752154.7505.593.camel@haggis
Whole thread Raw
In response to Re: How to do?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Fri, 2003-08-01 at 09:56, Shridhar Daithankar wrote:
> On 1 Aug 2003 at 9:47, Ron Johnson wrote:
>
> > On Wed, 2003-07-30 at 07:17, Robert Partyka wrote:
> > > Hi,
> > >
> > > Have question....
> > >
> > > How to do such like this:
> > >
> > > I have: select <column list> form <tables> where <where statement>;
> > > how to make one column be row numbers in result?
>
> select oid,name from a;
>
> It's oid. Of course you need to have them enabled since they are optional in
> recent versions..

Oh, *that* row number...

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: How to do?
Next
From: Ron Johnson
Date:
Subject: Re: extract and time zones