On 04/23/2016 08:09 AM, Geoff Winkless wrote:
On 23 April 2016 at 07:08, Manuel Gómez <tar...@gmail.com> wrote:
but its semantics can be rather wonky. Witness:
postgres=# select 1;
?column?
----------
1
(1 row)
postgres=# select 1 union select 1;
?column?
----------
1
(1 row)
Exactly what you would expect. Use UNION ALL to get two rows.
Exactly, a simple reading the docs will explain this:
http://www.postgresql.org/docs/9.5/static/queries-union.html
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
