Postgres Pro
Downloads
Home   >   mailing lists

Re: question about to return two diferent tables from a function - Mailing list pgsql-general

From Michael Fuhr
Subject Re: question about to return two diferent tables from a function
Date
Msg-id 20050924040757.GA23964@winnie.fuhr.org
Whole thread Raw
In response to question about to return two diferent tables from a function  (hildebardo@prodigy.net.mx)
List pgsql-general
Tree view 
On Fri, Sep 23, 2005 at 07:55:32PM -0500, hildebardo@prodigy.net.mx wrote:
> I have two tables
[...]
> then I need to join the two tables in a function  like this
>
> doc|date      |id
> 1  |2005-09-22| 50
> 2  |2005-09-21| 50
> 12 |2005-09-01| 20
> 13 |2005-09-21| 24
> 14 |2005-09-22| 31

This doesn't look like a join of the two tables; it looks instead
like a union.  Is this the query you're looking for?

SELECT doc, date, id_customer AS id FROM first_one
UNION ALL
SELECT doc, date, id_code AS id FROM second_one;

--
Michael Fuhr

pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: Re: array_dims array_lower/upper distance
Next
From: Ron Mayer
Date:
Subject: Re: Backend crash with user defined aggregate