Re: Proper relational database?

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.