| From: | LALIT KUMAR <lalit(dot)jss(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Compare rows |
| Date: | 2011-07-13 06:15:20 |
| Message-ID: | CAMojEG+D5uNfiE5ChJp37pbJVQsB007S9WYo-GonmbNR04tFrA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
I have the following table.
city Rate flag
A 10 0
A 20 1
A 30 0
A 2 0
A 23 1
A 12 0
B 5 1
B 43 0
C 23 1
C 67 1
For every city I have so set the flag as -1 in row which is 0 above the row
having flag as 1.
So my out would be:
city Rate flag
A 10 -1
A 20 1
A 30 0
A 2 -1
A 23 1 (not changed to -1 as it not 0)
A 12 0 (not changed to -1 because i need to compare
it to row of same city. so being last row not compared with any row)
----------------------------------------------------
B 5 1
B 43
C 23 1
C 67 1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2011-07-13 08:30:25 | Re: Compare rows |
| Previous Message | Greg Sabino Mullane | 2011-07-12 15:14:37 | Re: pgpass.cong file becomes empty |