On 05/03/12 05:08, Chris Angelico wrote:
On Mon, Mar 5, 2012 at 3:15 PM, Tom Molesworth<tom@xxxxxxxxxxxxxxxxx> wrote:Can you use to_number() here? It sounds like something along the lines of cast(to_number('0' || field::varchar, '999999999.') as int) might give the behaviour you're after, and a quick test seems to indicate that it's about 4x faster than the original function:I looked at to_number but it seems to find digits anywhere inside the field - to_number('12.34','99999') returns 1234, but I want it to stop at the decimal.
Right - that's why I included the . in the format string. Haven't done exhaustive testing but it seemed to do what you were after.
cheers, Tom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
