Re: Effective query for listing flags in use by messages in a folder

På onsdag 18. mars 2015 kl. 13:54:50, skrev Hector Vass <
hector(dot)vass(at)metametrics(dot)co(dot)uk <mailto:hector(dot)vass(at)metametrics(dot)co(dot)uk>>: OK I get
it ..

drop type if exists myflags cascade; create type myflags as
enum('is_seen','is_replied','is_forwarded','is_deleted','is_draft','is_flagged');
drop table if exists message; create table message(     folder_id integer not
NULL,     msg varchar(200),     is_flag myflags ); insert into message values
(1,'msg b','is_seen'), (1,'msg c','is_seen'), (1,'msg d','is_seen'), (1,'msg
d','is_replied'), (1,'msg e','is_seen'), (1,'msg e','is_replied'), (1,'msg
h','is_deleted') ;   Not quite; you have 2 entries, one for each flag, for "msg
d". I must haveone tuple per message in this table.   -- Andreas Joseph Krogh
CTO / Partner - Visena AS Mobile: +47 909 56 963 andreas(at)visena(dot)com
<mailto:andreas(at)visena(dot)com> www.visena.com <https://www.visena.com>
<https://www.visena.com>