Re: plpgsql return select from multiple tables

From: "Artis Caune" <artis(dot)caune(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: plpgsql return select from multiple tables
Date: 2008-09-10 14:34:18
Message-ID: 9e20d71e0809100734j43ccf42fr2d1f3c5516a67e46@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 10, 2008 at 5:26 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2008-09-10 14:38:56 Re: [GENERAL] FW: How to upload data to postgres
Previous Message Alvaro Herrera 2008-09-10 14:26:13 Re: plpgsql return select from multiple tables