select distinct error ? - Mailing list pgsql-general

From Henrik Steffen
Subject select distinct error ?
Date
Msg-id 023201c233d8$02a649c0$7100a8c0@topconcepts.net
Whole thread Raw
Responses Re: select distinct error ?
List pgsql-general
hello all,

i am just experiencing something weird:

select distinct foo from bar where foobar like 'foobar%';

gives:

 foo
--------
 090700
 090701
 090702
 090700
(4 rows)

foo is character(6)

How can this happen??


Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------



pgsql-general by date:

Previous
From: ratlhead@ratlhead.com (ratlhead)
Date:
Subject: Re: Shell Script help for backup
Next
From: "Bjoern Metzdorf"
Date:
Subject: Re: erserver