DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=GlmS8s1hTgftbUT+nkUzsC2vQYg146vK1wF9ChKg67Zi12cQPmeBmGF13vtJ2q7wBzyBn2FEI0lbahmGQbQLg2c+DU5rq/kN34whdRRMRpcgHfydwdRK2o8hDkPU9ACNpiTNQLV3GQXL4y8+O10VCMJBMoXH1hoZ/sE2QlSdRVU=
Message-ID: <e431ff4c050909052360490fc2@mail.gmail.com>
Date: Fri, 9 Sep 2005 16:23:00 +0400
From: Nikolay Samokhvalov <samokhvalov@gmail.com>
Reply-To: nikolay@samokhvalov.com
To: pgsql-sql@postgresql.org
Subject: SELECT: retrieve only 2 rows next to known row
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

My knowledge of PostgreSQL's SQL is not good, but I know ISO/ANSI
SQL:2003 (basics) quite well.

I've encountered with following task. I have one SELECT statement with
ORDER BY clause; and know, that result set for this SELECT contains
row with ID =3D 1000 (just for example).
I don't know the position of this row in result set, but I want to
retrieve 2 rows that are next to this  one.

First of all, I don't want (cannot) write PL/pgSQL function.

So, I should use CREATE TEMP SEQUENCE to associate all rows in result
set with their order numbers (in MySQL. for example, I would use
temporary variable num in SELECT: something like 'select @num :=3D @num
+ 1', but here I cannot, can't I?)

Then, as I know, PostgreSQL doesn't support standard statement WITH,
that probaby would help me with this task.

Any ways to solve this problem? Is it possible to make only one query?
(at least with one row in result set - e.g., with the row _following_
after my one)

I'd appreciate any help.

--=20
Best regards,
Nikolay