Content-Type: multipart/signed;
 boundary="Apple-Mail=_D5797304-9CE1-44F6-99E9-980A9294FD88";
 protocol="application/pkcs7-signature"; micalg=sha1
Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.6\))
Subject: Re: How to get the position of each record in a SELECT statement
From: =?iso-8859-1?Q?Adelo_Herrero_P=E9rez?= <adelo.herrero@gmail.com>
In-Reply-To: 
 <CAAY=A7_PdEeLWtQev0ZDnky9b4PzU1QHn0JYK4S5fS4qXG3kig@mail.gmail.com>
Date: Sat, 8 Oct 2016 09:35:58 +0200
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Message-Id: <DC6D85EA-4B7E-424D-824E-A8D645E9BC33@gmail.com>
References: 
 <CAAY=A7_PdEeLWtQev0ZDnky9b4PzU1QHn0JYK4S5fS4qXG3kig@mail.gmail.com>
To: JORGE MALDONADO <jorgemal1960@gmail.com>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org


--Apple-Mail=_D5797304-9CE1-44F6-99E9-980A9294FD88
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1


El 07/10/2016, a las 19:20, JORGE MALDONADO <jorgemal1960@gmail.com> =
escribi=F3:

> Let=B4s say that I have the following simple SELECT statement:
>=20
> SELECT first, id FROM customers ORDER BY first
>=20
> This would result in something like this:
> Charles    C1001
> John        A3021
> Kevin      F2016
> Paul        N4312
> Steve      J0087
>=20
> Is it possible to include a "field" in the SELECT such that it =
represents the position of each record?
> For example, I need to get a result like this:
>=20
> 1    Charles    C1001
> 2    John        A3021
> 3    Kevin      F2016
> 4    Paul        N4312
> 5    Steve      J0087
>=20
> Respectfully,
> Jorge Maldonado

Hi:

If you need the order in the result (not physically) can try this code:

SELECT=20
       (SELECT COUNT(*)
          FROM customers o
         WHERE (o.first =3D c.first) and (o.id =3D c.id)) AS position,
       c.first,
       c.id   =20
  FROM customers c=20
  order by c.first

Hope this help,
Best regards.


--Apple-Mail=_D5797304-9CE1-44F6-99E9-980A9294FD88
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGnzCCBpsw
ggWDoAMCAQICEBiGMlW4uHy1Vwdmc+5CpuYwDQYJKoZIhvcNAQELBQAwSzELMAkGA1UEBhMCRVMx
ETAPBgNVBAoMCEZOTVQtUkNNMQ4wDAYDVQQLDAVDZXJlczEZMBcGA1UEAwwQQUMgRk5NVCBVc3Vh
cmlvczAeFw0xNjA0MDgwODA2MTFaFw0yMDA0MDgwODA2MTFaMHMxCzAJBgNVBAYTAkVTMRIwEAYD
VQQFEwk3MzY1NDM5MUwxFjAUBgNVBAQMDUhFUlJFUk8gUEVSRVoxDjAMBgNVBCoMBUFERUxPMSgw
JgYDVQQDDB9IRVJSRVJPIFBFUkVaIEFERUxPIC0gNzM2NTQzOTFMMIIBIjANBgkqhkiG9w0BAQEF
AAOCAQ8AMIIBCgKCAQEA3oVGdiwMEe3QKvdYjEFgwCmxX9M/vA1reuoU11MQT28EdbHFMycZ9VRl
nvdoYXC5iT4/RQ2TxF/Fd4JNk1RfXHa7gL0I/pnwQfdBqlUU6s3dizueFkzDA9WoNZ8rVWkVzI61
HHqMyyGjim1AiT1rjuf5V0kK2iKIBER/X2I5uja2rTEjDBgYhZA/FM6PBMwFHpko5OHVNay8ld3b
F2nEMsL+QHAfbHZzihxYzQCE9TBmP8Y/AwlpAQLvNQB/rBBzgwa97hag3+u1fpUdH2ubUV0tIAId
PlJUI8LunX7Fc1XjjGh8fxF9qE7GqS5ZNF5qOEFIYAIlum5ZxcANhxZTswIDAQABo4IDUTCCA00w
gYQGA1UdEQR9MHuBF2FkZWxvLmhlcnJlcm9AZ21haWwuY29tpGAwXjEYMBYGCSsGAQQBrGYBBAwJ
NzM2NTQzOTFMMRQwEgYJKwYBBAGsZgEDDAVQRVJFWjEWMBQGCSsGAQQBrGYBAgwHSEVSUkVSTzEU
MBIGCSsGAQQBrGYBAQwFQURFTE8wDAYDVR0TAQH/BAIwADAOBgNVHQ8BAf8EBAMCBeAwIwYDVR0l
BBwwGgYIKwYBBQUHAwQGCCsGAQUFBwMCBgRVHSUAMB0GA1UdDgQWBBQdQJOd6hLD5nMomWovxfPH
fH0a4TAfBgNVHSMEGDAWgBSx1E/EI3n6RAUJxus5z+g1sLggZDCBggYIKwYBBQUHAQEEdjB0MD0G
CCsGAQUFBzABhjFodHRwOi8vb2NzcHVzdS5jZXJ0LmZubXQuZXMvb2NzcHVzdS9PY3NwUmVzcG9u
ZGVyMDMGCCsGAQUFBzAChidodHRwOi8vd3d3LmNlcnQuZm5tdC5lcy9jZXJ0cy9BQ1VTVS5jcnQw
gd0GA1UdIASB1TCB0jCBzwYKKwYBBAGsZgMKATCBwDApBggrBgEFBQcCARYdaHR0cDovL3d3dy5j
ZXJ0LmZubXQuZXMvZHBjcy8wgZIGCCsGAQUFBwICMIGFDIGCQ2VydGlmaWNhZG8gcmVjb25vY2lk
by4gU3VqZXRvIGEgbGFzIGNvbmRpY2lvbmVzIGRlIHVzbyBleHB1ZXN0YXMgZW4gbGEgRFBDIGRl
IGxhIEZOTVQtUkNNIChDL0pvcmdlIEp1YW4gMTA2LTI4MDA5LU1hZHJpZC1Fc3Bhw7FhKTAlBggr
BgEFBQcBAwQZMBcwCAYGBACORgEBMAsGBgQAjkYBAwIBDzCBtAYDVR0fBIGsMIGpMIGmoIGjoIGg
hoGdbGRhcDovL2xkYXB1c3UuY2VydC5mbm10LmVzL2NuPUNSTDU0Mixjbj1BQyUyMEZOTVQlMjBV
c3VhcmlvcyxvdT1DRVJFUyxvPUZOTVQtUkNNLGM9RVM/Y2VydGlmaWNhdGVSZXZvY2F0aW9uTGlz
dDtiaW5hcnk/YmFzZT9vYmplY3RjbGFzcz1jUkxEaXN0cmlidXRpb25Qb2ludDANBgkqhkiG9w0B
AQsFAAOCAQEAcnbW9VKe5c+pYVvhpKg0JBhMfkD/mwX459sIwh1gnGJ7r1GlVQmI5EKL0O+7ddw6
5sqFwHPevPW8CJX/+gwX0uPyBHTYs6weaDm/YCpJ62wk6r8xqKW2rkdF9M+vcLTkOt5galYVDJtz
lrj9LVyb6AUSeeK2UggktwoCBIyRKpxh9okKUdHgi11bnqs9gTqACFBppCDS2tDMgCMaqwgfd5Ch
LEHDFv8hiJBZ1ByT9/eNREx6kga6A3vWuTJUArMs/PX+F8Thr/6P376ouDxRjuYu/GODuxhcuUD7
864X/rzazRK4nbloj1DDaMglgO1g9+9GGIHa4TcOPc+wjoEnozGCAskwggLFAgEBMF8wSzELMAkG
A1UEBhMCRVMxETAPBgNVBAoMCEZOTVQtUkNNMQ4wDAYDVQQLDAVDZXJlczEZMBcGA1UEAwwQQUMg
Rk5NVCBVc3VhcmlvcwIQGIYyVbi4fLVXB2Zz7kKm5jAJBgUrDgMCGgUAoIIBPzAYBgkqhkiG9w0B
CQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xNjEwMDgwNzM1NTlaMCMGCSqGSIb3DQEJ
BDEWBBT7mJvJ+37xO4+EdxkgjyrZqHqsrTBuBgkrBgEEAYI3EAQxYTBfMEsxCzAJBgNVBAYTAkVT
MREwDwYDVQQKDAhGTk1ULVJDTTEOMAwGA1UECwwFQ2VyZXMxGTAXBgNVBAMMEEFDIEZOTVQgVXN1
YXJpb3MCEBiGMlW4uHy1Vwdmc+5CpuYwcAYLKoZIhvcNAQkQAgsxYaBfMEsxCzAJBgNVBAYTAkVT
MREwDwYDVQQKDAhGTk1ULVJDTTEOMAwGA1UECwwFQ2VyZXMxGTAXBgNVBAMMEEFDIEZOTVQgVXN1
YXJpb3MCEBiGMlW4uHy1Vwdmc+5CpuYwDQYJKoZIhvcNAQEBBQAEggEAc7cKGcLJdOUDQwIiOHSP
wFdjscOqcXctb+ypUMIth+hhET6d+k5NafjG6UeaRXpfMmW4rjPGA0hTARWJ4v9mExCHJIFYqbw1
/L/2NzvTA1lIvn9qjQtAQslCp79N9m1oAVtycbG3EwPvSgx4zND0PO+2oEGGpVECOZxK7QZdTMgu
gKL2enF0thd5+cBdOmPSahcSJPwYJp3iQXQ9emGDdwDvOuH+qLo/RAPSyOnM72rot4XmSWvBAIdg
FZR/fZCP7thZXETMSBCcVBBLfP/dr7doVbPGacznx+Mofh5sEgUtLxnEJMOsKoDuzjVi1gY0tSFc
zGWilQ6Q6InzYIeIpQAAAAAAAA==

--Apple-Mail=_D5797304-9CE1-44F6-99E9-980A9294FD88--