Postgres OnLine Journal

Entries tagged as except

PostGIS in Action PostgreSQL: Up and Running Book Store About the Authors Consulting PostgreSQL PostGIS

Learn more about O'Reilly Open Source Convention

Buy PostGIS in Action from Amazon or Manning

PGCon 2013 Ottawa May 22nd-24th 2013

FOSS4G 2013 Nottingham 17th-21st September 2013

Entries tagged as except

Friday, June 08. 2012

Finding contiguous primary keys

Printer Friendly

Recommended Books: PostgreSQL: Up and Running PostGIS in Action

I recently had the need to figure out which ranges of my keys were contiguously numbered. The related exercise is finding gaps in data as well. Reasons might be because you need to determine what data did not get copied or what records got deleted. There are lots of ways of accomplishing this, but this is the first that came to mind. This approach uses window aggregates lead function and common table expressions, so requires PostgreSQL 8.4+

Continue reading "Finding contiguous primary keys"

Posted by Leo Hsu and Regina Obe in 8.4, 9.0, 9.1, 9.2, intermediate, postgresql versions, q&a at 16:29 | Comments (2) | Trackbacks (0)

Defined tags for this entry: common table expressions, cte, except, window, window functions

Related entries by tags:

(Page 1 of 1, totaling 1 entries)

Quicksearch

Calendar

Archives

Syndicate This Blog

Powered by

Serendipity PHP Weblog

Blog Administration

Open login screen

Remote RSS/OPML-Blogroll Feed

No RSS/OPML feed selected