select distinct error ?

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: "pg" <pgsql-general(at)postgresql(dot)org>
Cc: "Snke Ruempler" <soenke(at)ruempler(dot)de>
Subject: select distinct error ?
Date: 2002-07-25 12:37:15
Message-ID: 023201c233d8$02a649c0$7100a8c0@topconcepts.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)topconcepts(dot)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
--------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message terry 2002-07-25 12:41:20 FW: pg_clog error
Previous Message Martijn van Oosterhout 2002-07-25 12:36:10 Re: Getting a Database List