not reducing same values in IN - Mailing list pgsql-hackers

From vojtech@hafro.is
Subject not reducing same values in IN
Date
Msg-id 684b7d47.0309120632.2e8b8bff@posting.google.com
Whole thread Raw
Responses Re: not reducing same values in IN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello,

I'd like to ask some pg developer how complicated task would
be to patch query processing (most likely parser) to allow
for the following non-sql change. For a certain scientific
application where a bootstrapping of data is needed I would
like to select from a database "with replacement", i.e.
to be able to send "SELECT col FROM tab WHERE col IN (5,5)"
and receive two line of output (two fives) where only one
is stored in the database. One way is to workaround by 
with SELECT ... col IN (5) UNION ALL SELECT ... col IN (5),
for complex queries however, I run into difficulties.
Would a rather small patch at some point in the source code 
made this possible or it sounds a bit unrealistic? 
Thank you.

--Vojtech


pgsql-hackers by date:

Previous
From: miko@idocs.com (Miko O'Sullivan)
Date:
Subject: Re: massive quotes?
Next
From: "Relaxin"
Date:
Subject: Re: Vote: Adding flex/bison derived files in WIN32_DEV