Re: [HACKERS] Same expression more than once in partition key - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Same expression more than once in partition key
Date
Msg-id 1c49fd18-538a-e5f3-b7a2-b787022a5369@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Same expression more than once in partition key  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Same expression more than once in partition key
List pgsql-hackers
On 6/23/17 09:54, Tom Lane wrote:
>> However, I can use same expression more than once in partition key.
> 
> ... and so, I can't get excited about extending it to expressions.
> Where would you stop --- for example, are i and (i) equal?  What
> about (i) and (case when true then i else j end)?  In principle,
> the system could recognize both those identities, but it seems
> silly to expend code on it just for nagware purposes.

We also allow the same column more than once in an index.  We probably
don't have to be more strict here.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] pgjdbc logical replication client throwing exception
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] shift_sjis_2004 related autority files are remaining