I am using postgres. Using pgadmin III, looking at the table "mailboxes" -
I can see the very unique name of a mailbox I just imported 1000 messages
into - and its mailbox_idnr is 37.
My query must be wrong because I get no records returned:
SELECT messageblk,dbmail_messageblks.physmessage_id
FROM dbmail_messageblks,dbmail_messages
where mailbox_idnr=37
and dbmail_messageblks.physmessage_id=dbmail_messages.message_idnr
and is_header=1
LIMIT 100;
There is a certain mailbox_idnr --- "3" - which does give results. Sorry,
I am obviously working in the dark here and not having a clear
understanding of how to retrieve a set of records representing the headers
for a particular folder aka mailbox_idnr.
