On 04/23/2016 08:09 AM, Geoff Winkless wrote:
> On 23 April 2016 at 07:08, Manuel Gómez <targen@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.