[GENERAL] Unsubscribe

How do I unsubscribe from postgres general list      __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [GENERAL] function call error

[1] is not referring to 2 otherwise the cursor would have fetched the correct values matching 2 . think there is some type case which needs to be done to convert array type to integer .   Thanks for your inputs .   Vidya Sim Zacks <[EMAIL PROTECTED]> wrote: I would guess that the cursor is

Re: [GENERAL] function call error

getmatch(array[2]); getmatch-- (1 row) SampleDB=# select getmatch(array[3]); getmatch-- (1 row)   Thanks     Vidya Sim Zacks <[EMAIL PROTECTED]> wrote: I suppose you will want to use perform array_append(array,val) insteadof select. That is the plpgsql way to do it. Must have s

Re: [GENERAL] function call error

user requestCONTEXT:  SQL statement "SELECT  array_append( $1 , $2 )"PL/pgSQL function "getmatch" line 9 at select into variables   any help how to resolve this , like what mistake am I doing ?   Thanks Vidya Sim Zacks <[EMAIL PROTECTED]> wrote: Vidya,   Array_a

[GENERAL] function call error

that cannot accept a setCONTEXT:  PL/pgSQL function "getmatch" line 8 at return next   what is wrong in my function , anyhelp asap? Thanks Vidya      __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[GENERAL] Cursor problem

ginSampleDB$# syscur refcursor; SampleDB=#end;SampleDB$# $$ language sql;ERROR:  syntax error at or near "syscur" at character 68LINE 2: syscur refcursor;   How do I create a cursor .   Any help asap ? Thanks Vidya Do you Yahoo!? Yahoo! Small Business - Try our new resources site!