Re: BUG #5490: INSERT doesn't force cast from text to timestamp

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andy Balholm <andy(at)balholm(dot)com>, Postgres-Bugs <pgsql-bugs(at)postgresql(dot)org>, craig(at)postnewspapers(dot)com(dot)au, farid(at)zidsoft(dot)com, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Subject: Re: BUG #5490: INSERT doesn't force cast from text to timestamp
Date: 2010-06-07 16:32:26
Message-ID: AANLkTimhtFRnnbRifNmgvlvXoiI47mc1WaEYX0Yq7gFG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jun 7, 2010 at 3:52 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> Is there a way to make values of "undefined" type pass through the SELECT DISTINCT filter (getting checked for uniqueness) but remain "undefined" if all the values supplied for the column are "undefined"?

The concept of "uniqueness" depends on what data type the data is
interpreted as.

--
greg

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Piergiorgio Buongiovanni 2010-06-07 16:36:49 BUG #5492: Query performs slowly and sequence corrupted
Previous Message Piergiorgio Buongiovanni 2010-06-07 15:34:57 BUG #5491: Queries performing slowly