Re: [GENERAL] N-tile function in postgres

2012-09-24 Thread Rachel Owsley
Thank you, François!! Got it. :) From: François Beausoleil [mailto:franc...@teksol.info] Sent: Monday, September 24, 2012 3:37 PM To: Rachel Owsley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] N-tile function in postgres Le 2012-09-24 à 14:12, Rachel Owsley a écrit : Thank you

Re: [GENERAL] N-tile function in postgres

2012-09-24 Thread Rachel Owsley
, Rachel From: François Beausoleil [mailto:franc...@teksol.info] Sent: Monday, September 24, 2012 12:57 PM To: Rachel Owsley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] N-tile function in postgres Le 2012-09-24 à 12:32, Rachel Owsley a écrit : Hi, Can anyone help me with an aggre

[GENERAL] N-tile function in postgres

2012-09-24 Thread Rachel Owsley
Hi, Can anyone help me with an aggregate query I am having trouble with? I want to get the top 5 or top 10 most frequently shopped in merchant categories for each account holder at a bank and put each of the quintiles/deciles into separate columns. I would also like to put the average transact

Re: [GENERAL] General guidance: Levenshtein distance versus other similarity algorithms

2012-07-25 Thread Rachel Owsley
Thanks, Merlin. I will give that one a try. -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Wednesday, July 25, 2012 1:32 PM To: Rachel Owsley Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] General guidance: Levenshtein distance versus other

[GENERAL] General guidance: Levenshtein distance versus other similarity algorithms

2012-07-23 Thread Rachel Owsley
Hi, I am hoping you can give me some guidance here. I'm using postgresql 9.1. Basically, I'm trying to create a query on a table of businesses that will return all similar matches to a business name. This is a huge table, and there is a lot of variation in names. The length of the string can be