From: | "Sterpu Victor" <victor(at)caido(dot)ro> |
---|---|
To: | "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Can I unite 2 selects? |
Date: | 2015-01-29 19:55:42 |
Message-ID: | em4c3a1e80-37e9-498c-8275-64f0f4849c2e@victor-pc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you.
This is the syntax I was looking for.
------ Original Message ------
From: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
To: "Sterpu Victor" <victor(at)caido(dot)ro>; "PostgreSQL General"
<pgsql-general(at)postgresql(dot)org>
Sent: 1/29/2015 9:09:31 PM
Subject: Re: [GENERAL] Can I unite 2 selects?
On 01/29/2015 10:58 AM, Sterpu Victor wrote:
Hello
Can I write a query where I receive a single result set from many
queries?
Something like this: SELECT (SELECT 1 AS t1, 2 AS t2), (SELECT 3 AS t3)
I tried exactly this but the error is: "ERROR: subquery must return
only one column"
But I don't see why it must have only one column.
postgres(at)test=# SELECT * from (SELECT 1 AS t1, 2 AS t2) as t, (SELECT 3
AS t3) as s;
t1 | t2 | t3
----+----+----
1 | 2 | 3
Thank you
-- Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
From | Date | Subject | |
---|---|---|---|
Next Message | David G Johnston | 2015-01-29 20:03:38 | Re: Subselect with no records results in final empty set |
Previous Message | Sterpu Victor | 2015-01-29 19:54:01 | Subselect with no records results in final empty set |