Re: [SQL] Strings in UDFs

2004-03-02 Thread Ryan Riehle
omething about boolean values) when the WHERE CLAUSE was: WHERE contractcode ~* (''^'' || $1) ...that was what was really messing me up before! -Ryan Riehle -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Riehle Sent: Tuesday, March 02, 20

[SQL] Strings in UDFs

2004-03-02 Thread Ryan Riehle
UUGH. Ok... I am trying to write a pgsql function containing a regular expression within a substring() function and I just can't fugure it out, and by now I've wasted way about too much time trying. What am I doing wrong??? I am using the tool pgManager for debugging & it is creating this DDL i