<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Verdana}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Calibri","sans-serif";
color:#1F497D}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Verdana","sans-serif";
font-variant:normal!important;
color:#1F497D;
text-transform:none;
font-weight:normal;
font-style:normal;
text-decoration:none none;
vertical-align:baseline}
@page WordSection1
{margin:70.85pt 70.85pt 70.85pt 70.85pt}
-->
</style><style type="text/css" id="owaParaStyle">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body fpstyle="1" ocsi="0" vlink="purple" link="blue" lang="FR">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hi,<br>
<br>
You should have a look to generate_series : <br>
<br>
<a href="https://www.postgresql.org/docs/9.5/static/functions-srf.html" target="_blank">https://www.postgresql.org/docs/9.5/static/functions-srf.html</a><br>
<br>
<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF724675" style="direction: ltr;"><font color="#000000" size="2" face="Tahoma"><b>De :</b> postgis-users [postgis-users-bounces@lists.osgeo.org] de la part de Olivier Leprêtre [o.lepretre@gmail.com]<br>
<b>Date d'envoi :</b> jeudi 18 mai 2017 19:05<br>
<b>À :</b> 'PostGIS Users Discussion'<br>
<b>Objet :</b> [postgis-users] Create mutliple rows from a field<br>
</font><br>
</div>
<div></div>
<div>
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"">Hi,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">I have a table with 2 columns : id, x (x is an int from 0 to n)</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">Is it possible to create a query that will return x ranked rows for each id ?</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">with
</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">id x</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">A 2</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">B 3</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">C 1</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">D 4</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">will return</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">A 1</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">A 2</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">B 1</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">B 2</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">B 3</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">C 1</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">D 1</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">D 2</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">D 3</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">D 4</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">I searched with OVER, PARTITION, RANK... without success</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">Thanks,</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt; font-family:"Verdana","sans-serif"" lang="EN-US">Olivier</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
</div>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #D3D4DE">
<tbody>
<tr>
<td style="width:55px; padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" style="width:46px; height:29px" width="46" height="29"></a></td>
<td style="width:470px; padding-top:17px; color:#41424e; font-size:13px; font-family:Arial,Helvetica,sans-serif; line-height:18px">
Garanti sans virus. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" style="color:#4453ea" target="_blank">
www.avast.com</a> </td>
</tr>
</tbody>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" height="1" width="1"></a></div>
</div>
</div>
</div>
</body>
</html>