[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Select question
From:       Madison Kelly <linux () alteeve ! com>
Date:       2007-08-31 18:28:56
Message-ID: 46D85DE8.9080005 () alteeve ! com
[Download RAW message or body]

Merlin Moncure wrote:
> I seem to recall giving out a query about that in the IRC channel a
> while back...so if you got it from me, now I'll attempt to finish the
> job :-).
> 
> If you can get postfix to look at a view, maybe you could
> CREATE VIEW email_v AS
> SELECT
>        usr_email, dom_name,
>        b.dom_name||'/'||a.usr_email||'/inbox' AS email_file
> FROM users a, domains b
> WHERE
>  a.usr_dom_id=b.dom_id;
>   AND a.usr_email='mkelly'
>   AND b.dom_name='test.com';
> 
> and just
> select * from email_v where usr_email = 'mkelly' and dom_name = 'test.com';
> 
> merlin

   Hiya,

Nope, wasn't me, but I was indeed able to solve the problem with a few 
(I posted the details in a follow up). It was pretty similar to your 
suggestion, so you were certainly onto something. :)

Madi

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq
[prev in list] [next in list] [prev in thread] [next in thread]