Re: Proper relational database?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>, Manuel Gómez <targen(at)gmail(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, david(at)andl(dot)org, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Proper relational database?
Date: 2016-04-23 15:26:00
Message-ID: 571B9408.90801@commandprompt.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Gómez 2016-04-23 16:19:35 Re: Proper relational database?
Previous Message Geoff Winkless 2016-04-23 15:09:43 Re: Proper relational database?