On Tue, Feb 07, 2006 at 01:45:50 -0800,
"superboy143 (sent by Nabble.com)" <[EMAIL PROTECTED]> wrote:
>
> I have a table in which I have a field with format like 100101. It has many
> values like 100101, 100102, 100103, 100201, 100202, 100301. I have to write a
> query such that I have to get only distinct values such that they contain
> only the substring I need. If I give 10 as substring, then it should return
> only 100101 or 100102 but not both i.e if the last two characters are not
> same it should not return both of them. It should return only values starting
> with 10 the middle two values should be distinct and the last two characters
> may be anything.
You can probably use the Postgres extension DISTINCT ON to do what you want.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
