On Sat, Nov 10, 2007 at 07:31:39PM +0000, Simon Riggs wrote: > On Sat, 2007-11-10 at 11:22 -0500, Tom Lane wrote: > > Simon Riggs <[EMAIL PROTECTED]> writes: > > > Constants in indexes are just a strangeness we don't need. > > > If I invented zero-column tables
You don't have to. CREATE TABLE foo(); already works. As I understand it, this is there to allow people to rearrange tables completely--drop all the columns and replace them, for example--and not have that fail. Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
