What is the output you are trying to achieve? > However, the same phone number might have a prefix on occasion, example : > > name | phone_number > ---------------------- > james | 123456 > james | 00441234556 > james | 555666 > sarah | 567890 > sarah | 567890 > > as you can see, the first 2 James seems to belong together. > > running > > select name, phone_number from relation group by name, phone_number > > would not reflect this. > > I don't think there is a way to run something similar to this : > > select name, phone_number from relation group by name, %phone_number% > // or similar > > However, I believe there is a way, so I would like to here it from you :) > > Functions, sums .. please let me know.. > > Thank you in advance / Jennifer > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
