NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
use Perl Log In
TeeJay (2309)
TeeJay
(email not shown publicly)
http://www.aarontrevena.co.uk/
Working in Truro
Graduate with BSc (Hons) in Computer Systems and Networks
pm : london.pm, bath.pm, devoncornwall.pm
lug : Devon & Cornwall LUG
CPAN : TEEJAY [cpan.org]
irc : TeeJay
skype : hashbangperl
livejournal : hashbangperl [livejournal.com]
flickr :hashbangperl [flickr.com]
(email not shown publicly)
http://www.aarontrevena.co.uk/
Working in Truro
Graduate with BSc (Hons) in Computer Systems and Networks
pm : london.pm, bath.pm, devoncornwall.pm
lug : Devon & Cornwall LUG
CPAN : TEEJAY [cpan.org]
irc : TeeJay
skype : hashbangperl
livejournal : hashbangperl [livejournal.com]
flickr
Wednesday March 22, 2006
05:35 AM
more postgres lameness
Just as I thought Postgres' quirky behaviour was having less of an impact on development I hit this lame barrier :
SELECT DISTINCT ON expressions must match initial ORDER BY expressions
It's entirely reasonable to want unique by pk, but order by a date field, thats' the kind of thing we use databases for, but no - Postgres requires that the distinct restriction matches the order by.
Very lame and incredibly annoying
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
Or is it a BUG?"
"Let's call it an accidental feature. :-)"
--Larry Wall in <6909@jpl-devvax.JPL.NASA.GOV>
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
work around (Score:2)
@JAPH = qw(Hacker Perl Another Just);
print reverse @JAPH;