Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 630328B63D8
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Jun 2012 11:11:33 -0300 (ADT)
Received: from mail-pb0-f46.google.com ([209.85.160.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1ShLd0-0006YX-UP
	for pgsql-performance@postgresql.org; Wed, 20 Jun 2012 14:11:32 +0000
Received: by pbbrp8 with SMTP id rp8so658136pbb.19
	for <pgsql-performance@postgresql.org>;
	Wed, 20 Jun 2012 07:11:12 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:x-gm-message-state;
	bh=EPbo5bmf1W5StRs9ptpSZB2+JjxTQAvthD1seP9fnvY=;
	b=jRllO/mrJYgtSX4SthxmP4pDKWzKQGSoI8Ftpn+tfopz//Nf/83dlLAlNF9unqKH5h
	bHNG42mtuaGisRBzjWwTOyTxqz7kDRXHefaoKgnIP39qFOdSKiMdO2mBLfPJW1DwFIqD
	gilWADv4eiQe6equa9oMv4x5ByVXXySO9mpG1fuuis60fHX/GrvprD+u8V6rAQ3qVopo
	AR5cHfGE4VATTXbabfHJUUVKFJapsOVjPdqn8NZTNnM3QHrWhzvf7VXwXWeAvL9z9Brj
	TSql6Q3PtGm8zpeBTQc+NO272JKuHghSdWTJukFQuiZlZip7c4kVa+1AAVovJJDLtQFO
	MVbQ==
Received: by 10.68.225.6 with SMTP id rg6mr78146095pbc.100.1340201472510;
	Wed, 20 Jun 2012 07:11:12 -0700 (PDT)
Received: from ayaki.localdomain ([106.71.181.145])
	by mx.google.com with ESMTPS id vc6sm32071433pbc.6.2012.06.20.07.11.09
	(version=SSLv3 cipher=OTHER); Wed, 20 Jun 2012 07:11:11 -0700 (PDT)
Message-ID: <4FE1D9F9.1020805@ringerc.id.au>
Date: Wed, 20 Jun 2012 22:11:05 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:13.0) Gecko/20120605 Thunderbird/13.0
MIME-Version: 1.0
To: Eyal Wilde <eyal@impactsoft.co.il>
CC: pgsql-performance@postgresql.org
Subject: Re: index-only scan is missing the INCLUDE feature
References: 
 <CAMiEbcjxN7cRYGtRMZuxEoztEOMB4us+pSdanwSkRY=ocJiQ8Q@mail.gmail.com>
In-Reply-To: 
 <CAMiEbcjxN7cRYGtRMZuxEoztEOMB4us+pSdanwSkRY=ocJiQ8Q@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------090002030606060508020003"
X-Gm-Message-State: 
 ALoCoQk9cdrWepk4G/mWnnHB0BYubeICaX0BE/SwVT8fKlbT5TRSyZzrooOMhnxsCRgwn1F5PTMW
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/109
X-Sequence-Number: 47135

This is a multi-part message in MIME format.
--------------090002030606060508020003
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 06/20/2012 12:46 PM, Eyal Wilde wrote:
> Hi all,
>
> as far as i looked around about the new feature: index-only scan, i 
> guess this feature will not include the option such as ms-sql INCLUDE.
>
For those of us who don't know MS-SQL, can you give a quick explanation 
of what the INCLUDE keyword in an index definition is expected to do, or 
some documentation references? It's possible to guess it somewhat from 
your description, but it's helpful to be specific when asking a question 
about features from another DBMS.

--
Craig Ringer

--------------090002030606060508020003
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 06/20/2012 12:46 PM, Eyal Wilde
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAMiEbcjxN7cRYGtRMZuxEoztEOMB4us+pSdanwSkRY=ocJiQ8Q@mail.gmail.com"
      type="cite">
      <meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
      <div>Hi all,
        <div><br>
          <div>as far as i looked around about the new feature:
            index-only scan, i guess this feature will not include the
            option such as ms-sql INCLUDE.</div>
          <div><br>
          </div>
        </div>
      </div>
    </blockquote>
    For those of us who don't know MS-SQL, can you give a quick
    explanation of what the INCLUDE keyword in an index definition is
    expected to do, or some documentation references? It's possible to
    guess it somewhat from your description, but it's helpful to be
    specific when asking a question about features from another DBMS.<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------090002030606060508020003--