Re: [SQL] Strings in UDFs

Ok... just got it (finally)... pgManager output the following and it works: *** CREATE FUNCTION "public"."ftcnum" (VARCHAR) RETURNS INTEGER AS' DECLARE maxcnt int4 := 0; begin SELECT into

[SQL] Strings in UDFs

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