Project

General

Profile

Bug #7282

the aggregate function max(boolean) does not exist on postgres, only sqlite

Added by Benjamin Dauvergne over 4 years ago. Updated about 2 years ago.

Status:
Fermé
Priority:
Normal
Assignee:
Benjamin Dauvergne
Category:
-
Target version:
2.2.0
Start date:
19 May 2015
Due date:
% Done:

100%

Patch proposed:
No
Planning:
No

Description

I'm looking at creating my own aggregate function1 and adding it using a conditional migration.

[1]: http://www.postgresql.org/message-id/m3pstupmog.fsf@mobile.int.cbbrowne.com

Associated revisions

Revision 58ed6232 (diff)
Added by Benjamin Dauvergne over 4 years ago

django_rbac: the aggregate function max(boolean) does not exist on postgres, only sqlite

fixes #7282

History

#1 Updated by Benjamin Dauvergne over 4 years ago

  • Description updated (diff)

#2 Updated by Benjamin Dauvergne over 4 years ago

Possible fix:

create or replace function bor (boolean, boolean)
  returns boolean as
$body$
select $1 or $2;
$body$ language sql;

create aggregate max(boolean) (
  sfunc=bor,
  stype=boolean,
  initcond=false,
);

#3 Updated by Benjamin Dauvergne over 4 years ago

This custom aggregate is installed on cresson.

#4 Updated by Benjamin Dauvergne over 4 years ago

  • Status changed from Nouveau to Résolu (à déployer)
  • % Done changed from 0 to 100

#5 Updated by Benjamin Dauvergne almost 4 years ago

  • Status changed from Résolu (à déployer) to Solution déployée

#6 Updated by Benjamin Dauvergne about 2 years ago

  • Status changed from Solution déployée to Fermé

Also available in: Atom PDF