Skip site navigation (1) Skip section navigation (2)

Re: count(*) of zero rows returns 1

From: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: count(*) of zero rows returns 1
Date: 2013-01-15 03:25:39
Message-ID: CABwTF4UxfLD-2vT7Wj_gCNOeo0k_i1XEE40xxxt0yVAr9EmCwA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Jan 14, 2013 at 3:09 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> What does "SELECT * FROM dual" in Oracle yield?
>

AFAICR, 'dual' table has one column named 'DUMMY' and one row with value,
single character X.

-- 
Gurjeet Singh

http://gurjeet.singh.im/

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2013-01-15 03:26:39
Subject: Re: [PATCH] Compile without warning with gcc's -Wtype-limits, -Wempty-body
Previous:From: Abhijit Menon-SenDate: 2013-01-15 03:12:28
Subject: Re: logical changeset generation v4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group