Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 04DE71337B3E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  3 May 2011 00:52:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 57693-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  3 May 2011 03:52:07 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id 93DCE133798E
	for <pgsql-admin@postgresql.org>; Tue,  3 May 2011 00:52:05 -0300 (ADT)
Received: by wya21 with SMTP id 21so4645551wya.19
	for <pgsql-admin@postgresql.org>; Mon, 02 May 2011 20:52:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:date:message-id:subject:from:to
	:content-type; bh=IGPMkTYS2wfLZoRF9gFhqPPyDbHdlwXr/lofuDGxNs8=;
	b=eCCo5SbEQHhEw+dvRdZHF4bXrS55/pljsSGKbxKbACr8hEWf7u8zEj1GB+a+RQoqSl
	PEyhCDdo8i6x/37fzXr65wKAEsFdfJO1aY7w6+BPyFIhIJC2yyLYBvZY9P18DfQX7TAS
	n2NVxu3usYTQIBq/HRHncLf+25fW3u7CnADvo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=mgWn4n9PAx/WuBSp6xQnobdCebu/K/IDffywLEx+vlq8Ro56HbgspfM33QQufiCb+G
	VbOgOFf8XpqviY23JSe+Hgqv6sAAxBXTG6z18Df7c2ee1rgozk0UB7wF8L1SlEJ1ItGg
	Ivyj8Upycf6vOKMGVM1CvIk+grt42hLOlfQvY=
MIME-Version: 1.0
Received: by 10.216.229.195 with SMTP id h45mr3248392weq.48.1304394724468;
	Mon, 02 May 2011 20:52:04 -0700 (PDT)
Received: by 10.216.178.3 with HTTP; Mon, 2 May 2011 20:52:04 -0700 (PDT)
Date: Mon, 2 May 2011 22:52:04 -0500
Message-ID: <BANLkTimkN8c4WVtNGQY0nbY_aPdR-yiEfg@mail.gmail.com>
Subject: simple question about using an empty string building a partial index
From: Tom Hartnett <tdhartnett@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=0016e644ccd432f2e004a2571036
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.887 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201105/13
X-Sequence-Number: 37450

--0016e644ccd432f2e004a2571036
Content-Type: text/plain; charset=ISO-8859-1

can it be done?

create index my_idx on my_table(col1) where col1='';

ERROR:  invalid input syntax for integer: ""

Seems simple enough but I don't know what the trick is.

--0016e644ccd432f2e004a2571036
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

can it be done?<br><br>create index my_idx on my_table(col1) where col1=3D&=
#39;&#39;;<br><br>ERROR:=A0 invalid input syntax for integer: &quot;&quot;<=
br><br>Seems simple enough but I don&#39;t know what the trick is.<br><div =
style=3D"visibility: hidden; left: -5000px; position: absolute; z-index: 99=
99; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word=
-wrap: break-word; color: black; font-size: 10px; text-align: left; line-he=
ight: 130%;" id=3D"avg_ls_inline_popup">
</div>

--0016e644ccd432f2e004a2571036--