pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
Cc: Richard Huxton <dev@archonet.com>
Cc: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: Oddity with view (now with test case)
Date: Tue, 11 Nov 2008 14:15:46 -0500
Message-ID: <10664.1226430946@sss.pgh.pa.us> (raw)
In-Reply-To: <03B6DDDD-C1E9-4897-864B-46892FCBE379@cashnetusa.com>
References: <3CF0CFC1-FDBA-4A61-ACAA-6AF556C4C6F4@cashnetusa.com>
	<3128.1226322412@sss.pgh.pa.us>
	<7B598355-07C0-450A-9914-B5979F48A5B3@cashnetusa.com>
	<49187BA7.8020403@archonet.com>
	<1E5A4D7D-3B95-440B-A377-B6B9F8768F7A@cashnetusa.com>
	<12776.1226345499@sss.pgh.pa.us>
	<C20FA82B-9FF8-4384-BC98-3D3D84001E17@cashnetusa.com>
	<9474.1226373609@sss.pgh.pa.us>
	<03B6DDDD-C1E9-4897-864B-46892FCBE379@cashnetusa.com>

"Jim 'Decibel!' Nasby" <jnasby@cashnetusa.com> writes:
> On Nov 10, 2008, at 9:20 PM, Tom Lane wrote:
>> 8.3 gets it right though.

> Doesn't seem to for me... :/

Oh, I was looking at "select * from v2" not "select count(*) from v2".
HEAD is a bit smarter about the latter than 8.3 is.

			regards, tom lane



view thread (8+ messages)  latest in thread

Message-ID: <10664.1226430946@sss.pgh.pa.us>
Permalink:  ../10664.1226430946@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/10664.1226430946@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, jnasby@cashnetusa.com, dev@archonet.com
  Subject: Re: Oddity with view (now with test case)
  In-Reply-To: <10664.1226430946@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox