#1
  1. No Profile Picture
    Mentat of IX
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    Bucuresti / Toronto
    Posts
    112
    Rep Power
    12

    returning a list of unique names


    Hi everybody ,
    I've just started with Postgres ( and databases in general ) about a week or so ago , so I'm sorry if my question might make me look like ... i'm new

    I have read a book on it and searched through a few sites , and there is one feature which I could not find .
    I was wondering if such a feature exists or there is a way of achieving this in postgres .

    Basically I have a table that say will return 10 names . 4 of these names would be unique and some of them will be repeated more than once within this table ...

    I'm searching for a way of listing only the unique names ...

    Thanks in advance
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    SELECT DISTINCT name_column FROM name_table;
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com
  4. #3
  5. No Profile Picture
    Mentat of IX
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Location
    Bucuresti / Toronto
    Posts
    112
    Rep Power
    12
    thank you , that's exactly what i needed ...

IMN logo majestic logo threadwatch logo seochat tools logo