Re: DISTINCT to get distinct *substrings*?

From: Christoph Pingel <ch(dot)pingel(at)web(dot)de>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: DISTINCT to get distinct *substrings*?
Date: 2006-08-08 18:52:35
Message-ID: E29F5655-863A-4745-8EB5-C062DB7D3D31@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Am 08.08.2006 um 19:49 schrieb Nikolay Samokhvalov:

> SELECT DISTINCT substring(attribute from '^http://[^/]*/') from pg_atp
> where attribute like 'http://%';
>
> w/o DISTINCT there should be duplicates (if any)
>
> don't use "DISTINCT ON" at all, it's evil :-) (why?
> http://chernowiki.ru/index.php?node=38#A13)

Thanks for the good advice! From reading this, it seems to be a
*really* bad thing. And I didn't get it from the official
documentation. :-)

ok, SELECT DISTINCT works, and it seems that the results are ordered
(by the substring) - is this the default behaviour or just by chance
(and probably version dependent)?

best regards,
Christoph

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jeffrey.bigham 2006-08-08 19:16:18 Accessing Database Data from C Function
Previous Message Ron Johnson 2006-08-08 18:48:31 Re: Practical maximums (was Re: PostgreSQL theoretical