Postgres Pro
Downloads
Home   >   mailing lists

Can I unite 2 selects? - Mailing list pgsql-general

From Sterpu Victor
Subject Can I unite 2 selects?
Date
Msg-id emdacd9d4e-9cbc-4ceb-a690-697451dece68@victor-pc
Whole thread Raw
Responses Re: Can I unite 2 selects?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Can I unite 2 selects?  (Edson Richter <edsonrichter@hotmail.com>)
Re: Can I unite 2 selects?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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.
 
Thank you


This email has been checked for viruses by Avast antivirus software.
www.avast.com



DISCLAIMER:
Acest mesaj de posta electronica si documentele aferente sunt confidentiale. Este interzisa distribuirea, dezvaluirea sau orice alt mod de utilizare a lor. Daca nu sunteti destinatarul acestui mesaj, este interzis sa actionati in baza acestor informatii. Citirea, copierea, distribuirea, dezvaluirea sau utilizarea in alt mod a informatiei continute in acest mesaj constituie o incalcare a legii. Daca ati primit mesajul din greseala, va rugam sa il distrugeti, anuntand expeditorul de eroarea comisa. Intrucat nu poate fi garantat faptul ca posta electronica este un mod sigur si lipsit de erori de transmitere a informatiilor, este responsabilitatea dvs. sa va asigurati ca mesajul (inclusiv documentele alaturate lui) este validat si autorizat spre a fi utilizat in mediul dvs.

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: 4B row limit for CLOB tables
Next
From: Adrian Klaver
Date:
Subject: Re: Can I unite 2 selects?