Re: Effective query for listing flags in use by messages in a folder - Mailing list pgsql-sql

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')

;

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@visena.com

www.visena.com