Monday, November 17. 2008 |
Calendar
Upcoming eventsScheduled events
Tentative events
CategoriesLatest commentsMon, 22.06.2009 04:50
I have an enterprise Apache/Mo
d_perl/PostgreSQL application
in development for aircraft di
spatch. The connection [...]
about Getting started at pgcon
Tue, 16.06.2009 20:44
Wed, 10.06.2009 21:40
Well, it assumes there are no
gaps, and that the sequence st
arts at a controlled value. An
d that there are no othe [...]
Tue, 09.06.2009 10:08
Assuming id's are coming witho
ut "holes" such statement may
be used:
SELECT * FROM cust
omer ORDER BY ABS(custno [...]
Fri, 05.06.2009 18:50
Fri, 05.06.2009 16:11
It's for just this kind of use
case that OLAP functions were
invented. The ROWS n (PRECED
ING|FOLLOWING) syntax si [...]
Fri, 05.06.2009 16:08
instead of doing select [*] fr
om (select ... limit) as a uni
on all, you can also use this
notation:
(select [*] [...]
about pgcon photos
Fri, 29.05.2009 18:46
Show tagged entriesTweets |
|||||||||||||||||||||||||||||||||||||||||||||||||