Skip site navigation (1) Skip section navigation (2)

BUG #1904: using distinct with null col causes error

From: "Brian Cox" <bcox(at)timestock(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1904: using distinct with null col causes error
Date: 2005-09-21 23:12:55
Message-ID: 20050921231255.11A8DF0B85@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1904
Logged by:          Brian Cox
Email address:      bcox(at)timestock(dot)com
PostgreSQL version: 8.0.3
Operating system:   Linux (Fedora Core 2)
Description:        using distinct with null col causes error
Details: 

any_db=> create view view1 as select null as col1 from any_table;
CREATE VIEW
any_db=> select distinct col1 from view1;
ERROR:  failed to find conversion function from "unknown" to text

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-09-22 02:59:37
Subject: Re: autovacuum doesn't seem to vacuum pg_attribute
Previous:From: Martin PittDate: 2005-09-21 22:12:30
Subject: autovacuum doesn't seem to vacuum pg_attribute

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group