X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FRecord.pm;h=43726411266252f41b5f2bfdfcd14cad4166f240;hp=60b25edcf933f143c83d829d486220a4fc1c6d26;hb=39e40f004fb217f825f695276d7a1b5a29a821d8;hpb=47c39af359fc93c777714a5c50a6183747b66da9 diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm index 60b25edcf..437264112 100644 --- a/FS/FS/Record.pm +++ b/FS/FS/Record.pm @@ -240,7 +240,8 @@ sub qsearch { } } elsif ( $op eq '!=' ) { if ( driver_name eq 'Pg' ) { - if ( $dbdef->table($table)->column($column)->type =~ /(int)/i ) { + my $type = $dbdef->table($table)->column($column)->type; + if ( $type =~ /(int|serial)/i ) { qq-( $column IS NOT NULL )-; } else { qq-( $column IS NOT NULL AND $column != '' )-;