Re: [GENERAL] Regular expression on a string problem.

2007-09-10 Thread Albe Laurenz
Paul Mendoza wrote: > Sent: Saturday, September 08, 2007 12:53 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Regular expression on a string problem. > > Here is a problem I'm having with a function I've created. It > should be returning a varchar value no

Re: [GENERAL] Regular expression on a string problem.

2007-09-08 Thread Richard Huxton
Paul Mendoza wrote: Here is a problem I'm having with a function I've created. It should be returning a varchar value no matter what the input is but I'm getting a null value back. Then it says in the error that I'm using "nonstandard use of escape in a string literal at character 9". What do you

[GENERAL] Regular expression on a string problem.

2007-09-07 Thread Paul Mendoza
Here is a problem I'm having with a function I've created. It should be returning a varchar value no matter what the input is but I'm getting a null value back. Then it says in the error that I'm using "nonstandard use of escape in a string literal at character 9". What do you think this should be