Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

Re: plpgsql return select from multiple tables - Mailing list pgsql-general

From Artis Caune
Subject Re: plpgsql return select from multiple tables
Date
Msg-id 9e20d71e0809100734j43ccf42fr2d1f3c5516a67e46@mail.gmail.com
Whole thread Raw
In response to Re: plpgsql return select from multiple tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: plpgsql return select from multiple tables
List pgsql-general
On Wed, Sep 10, 2008 at 5:26 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Hmm, maybe
>
> select email, backend from emails, backends where email.id = 1 and
> backend.id = 1;
> ?
>
> You don't need a plpgsql function for this ...

Ops, forget to mention that this function is not so simple and use
some plpgsql features.
Here is one of them:
http://dpaste.com/hold/77192/




--
regards,
Artis Caune

<----. CCNA
<----|====================
<----' didii FreeBSD

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: plpgsql return select from multiple tables
Next
From: Adrian Klaver
Date:
Subject: Re: FW: How to upload data to postgres