How to do?

From: Robert Partyka <R(dot)Partyka(at)wdg(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to do?
Date: 2003-07-30 12:17:07
Message-ID: 5.1.0.14.0.20030730141025.009ffb50@mail.alpha.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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? :-)

regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim McAuley 2003-07-30 12:46:46 Unused Indexes
Previous Message Peter Eisentraut 2003-07-30 11:57:31 Re: ERROR STRINGS IN PGSQL