Andy Colson wrote
> On 4/3/2014 11:09 AM, David Johnston wrote:
>> Andy Colson wrote
>>> On 4/3/2014 10:27 AM, Schnabel, Robert D. wrote:
I'm trying to figure out how to count the number of rows within a fixed
range of the current row value. My table looks like this:
SELECT chr
On 4/3/2014 11:09 AM, David Johnston wrote:
Andy Colson wrote
On 4/3/2014 10:27 AM, Schnabel, Robert D. wrote:
I'm trying to figure out how to count the number of rows within a fixed
range of the current row value. My table looks like this:
SELECT chr_pos
FROM mutations_crosstab_9615_99
WHERE
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David Johnston
Sent: Thursday, April 03, 2014 11:09 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] window function help
Andy Colson wrote
> On 4/3/2014 10
Andy Colson wrote
> On 4/3/2014 10:27 AM, Schnabel, Robert D. wrote:
>> I'm trying to figure out how to count the number of rows within a fixed
>> range of the current row value. My table looks like this:
>>
>> SELECT chr_pos
>> FROM mutations_crosstab_9615_99
>> WHERE bta = 38
>> LIMIT 10
>>
>> c
On 4/3/2014 10:27 AM, Schnabel, Robert D. wrote:
Hi,
I'm trying to figure out how to count the number of rows within a fixed range
of the current row value. My table looks like this:
SELECT chr_pos
FROM mutations_crosstab_9615_99
WHERE bta = 38
LIMIT 10
chr_pos
138
140
163
174
187
187
188
20
