On 04/23/2016 08:09 AM, Geoff Winkless wrote:
On 23 April 2016 at 07:08, Manuel Gómez <targen@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
