Re: select distinct error ? - Mailing list pgsql-general

From Tom Lane
Subject Re: select distinct error ?
Date
Msg-id 18657.1027610573@sss.pgh.pa.us
Whole thread Raw
In response to Re: select distinct error ?  ("Mario Weilguni" <mweilguni@sime.com>)
List pgsql-general
"Mario Weilguni" <mweilguni@sime.com> writes:
> try:
> SELECT distinct foo, length(foo) from bar where foobar like 'foobar%';
> maybe one has a blank attached?

He said the column was char(6), so they should all be padded to length
6.  I was wondering about nonprinting characters (carriage returns etc)
in the data, myself.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: regression test
Next
From: Tom Lane
Date:
Subject: Re: Auto DROP SEQUENCE?