From fedb482e844ea75e856da715082558b962dbdac1 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 2 Oct 2010 06:04:05 +0000 Subject: [PATCH] putting back the NUMERIC cast, it is needed git-svn-id: svn://svn.open-ils.org/ILS/trunk@18133 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../OpenILS/Application/Storage/Driver/Pg/QueryParser.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm index 9902269f94..76371bed4d 100644 --- a/Open-ILS/src/perlmods/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm +++ b/Open-ILS/src/perlmods/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm @@ -423,6 +423,7 @@ sub toSQL { my $plw = $filters{preferred_language_multiplier} ? $filters{preferred_language_multiplier} : $self->QueryParser->default_preferred_language_multiplier; $rel = "($rel * COALESCE( NULLIF( FIRST(mrd.item_lang) = $pl , FALSE )::INT * $plw, 1))"; } + $rel .= '::NUMERIC'; for my $f ( qw/audience vr_format item_type item_form lit_form language bib_level/ ) { my $col = $f; @@ -457,7 +458,7 @@ sub toSQL { if ($sort_filter eq 'title') { $rank = "FIRST((SELECT frt.value FROM metabib.full_rec frt WHERE frt.record = m.source AND frt.tag = 'tnf' AND frt.subfield = 'a' LIMIT 1))"; } elsif ($sort_filter eq 'pubdate') { - $rank = "FIRST(mrd.date1)"; + $rank = "FIRST(mrd.date1)::NUMERIC"; } elsif ($sort_filter eq 'create_date') { $rank = "FIRST((SELECT create_date FROM biblio.record_entry rbr WHERE rbr.id = m.source))"; } elsif ($sort_filter eq 'edit_date') { -- 2.43.2