[Dbmail] getting headers for a specific mailbox_idnr

[April Lorenzen]

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.