Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 2CB44B5D94C
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 21 Jun 2011 16:49:55 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 55067-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 21 Jun 2011 19:49:48 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp2.peak6.com (smtp2.peak6.com [38.98.137.9])
	by mail.postgresql.org (Postfix) with ESMTP id 9654EB5DBE2
	for <pgsql-performance@postgresql.org>;
	Tue, 21 Jun 2011 16:49:48 -0300 (ADT)
X-AuditID: 0a02cb1e-b7b55ae000000a02-f0-4e00f5daa3a8
Message-ID: <4E00F5DA.8090500@peak6.com>
Date: Tue, 21 Jun 2011 14:49:46 -0500
From: Shaun Thomas <sthomas@peak6.com>
Reply-To: <sthomas@peak6.com>
Organization: Peak6
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.13) Gecko/20101210 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
To: Jim Nasby <jim@nasby.net>
CC: Magnus Hagander <magnus@hagander.net>, Svetlin Manavski
	<svetlin.manavski@gmail.com>, <pgsql-performance@postgresql.org>
Subject: Re: seq scan in the case of max() on the primary key column
References: <BANLkTikntdSrhneCPzPutY9T-sAQpFXTMw@mail.gmail.com>
	<BANLkTikuFEyOse=sUoH0BXYrpUW=7Pp_tw@mail.gmail.com>
	<4DFA4D2F.8020101@peak6.com>
	<B7D0666C-FE18-4052-A2B1-0442E23CD5CC@nasby.net>
In-Reply-To: <B7D0666C-FE18-4052-A2B1-0442E23CD5CC@nasby.net>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
content-transfer-encoding: 7bit
X-Originating-IP: [10.10.221.50]
X-Brightmail-Tracker: 
 H4sIAAAAAAAAA+NgFnrJIsWRmVeSWpSXmKPExsXCxcQrpnvrK4OfwbQvVhZnb91ktFjx6Q6r
	xfWZ55gt5t49y+TA4rFz1l12j01tx5k9zh+eyuRxYd809gCWqAZGm8S8vPySxJJUhZTU4mRb
	pQBXR28zheCSxLyUxKIUBZfM4uScxMzc1CIlhcwUWyUjJYWCnMTk1NzUvBJbpcSCgtS8FCU7
	LgUMYANUlpmnkJqXnJ+SmZduq+QZ7K9rYWFqqWuoZBePAAltLBnH2hvZCq4yVTyetJulgbGP
	qYuRk0NCwERi+dK/zBC2mMSFe+vZQGxeAQ2JByefgsVZBFQl5t77A1bPJqAmsXD3TUYQW0hA
	VmL/qnOsIDa/gLDEvg9NYPWiAoUS347eYoaYIyhxcuYTFhBbBKh+6aL3YPXMAnUSX65tBosL
	C/hJXD3fCFTPBTTzMKPEplcrwJo5BWwlfqy/xgLRYCtxYc51KFteYvvbOcwQR8hJ3Gl4DnQ0
	B9ADChL3/jpNYBSahWT1LCTds5B0L2BkXsUoXlyWmJyRaVZQnFtSYKhXkJqYbaaXl1qyiREc
	4afldjCuuKB4iFGAg1GJh1fgHIOfEGtiWXFl7iFGCQ5mJRHe5K1AId6UxMqq1KL8+KLSnNTi
	Q4zawDCbyCzFnZwPTD55JfHGBgZK4rxfXN/6CgmkAxNBdmpqQWoRTDUTB6dUA6PmA3HrZTnO
	u29wJS6p+cxf3H7Ew4vvV9dH9bdTTu9a6ZGwad9278PCe/lUDL1+1koGvtTJetGlvMtOtuz9
	utzdCYYOyi55+l2XpPnUHsyK3zxj9g9Nsxl1J2V//V3N4MulWWMoGL990XSbNVIGsR+ajPny
	5tu56K9RPV5T5sxwwbr99JR5mkosxRmJhlrMRcWJALBh6if8AgAA
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201106/200
X-Sequence-Number: 44133

On 06/17/2011 03:31 PM, Jim Nasby wrote:

> c_parent_oid CONSTANT oid := (p_parent_schema || '.' ||
> p_parent_table )::regclass;

Well isn't *that* a handy bit of magic. How did I not know about that? 
Thanks!

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@peak6.com

______________________________________________

See  http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email