Re: How to do?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to do?
Date: 2003-08-01 14:47:38
Message-ID: 1059749258.7508.590.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
>
> and second one:
> have select like above.... and I know that in result is record with e.g.
> uid='AC13A1'.
> How to reduce result to this record and one record before in result and one
> record after in result?
>
> Are this questions just silly problems? :-)

No, but slightly ambiguous, at least for my old brain.

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

In response to

  • How to do? at 2003-07-30 12:17:07 from Robert Partyka

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-01 14:55:49 Re: extract and time zones
Previous Message Karsten Hilbert 2003-08-01 14:43:23 Re: PC color icon data?