Re: count(*) of zero rows returns 1

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>, David Johnston <polobo(at)yahoo(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: count(*) of zero rows returns 1
Date: 2013-01-21 20:10:28
Message-ID: CABRT9RB07-c-Nfbh3MVjkBn68Lx9sErp33e1oFhU2K9ztddJaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jan 21, 2013 at 9:33 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> test=# select * from foo1;
>> (No rows)
>> Time: 1012.567 ms
>
> How did you get that? I don't believe it's possible in the default
> output format.

Oh I see, it's because I have \x auto in my .psqlrc. If I set \x auto
or \x on then it says "(No rows)"

Regards,
Marti

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-01-21 20:19:43 Re: Removing PD_ALL_VISIBLE
Previous Message Tom Lane 2013-01-21 19:45:54 Re: pg_dump transaction's read-only mode