[GENERAL] Checking cursor's state in plpgsql

Hello all Can we check whether a cursor is OPEN or not in plpgsql. Like in oracle you can check a CURSOR'S state with %ISOPEN After navigating the documentation i was not able to find an equivalent in plpgsql. Do we have an alternative to this in plpgsql? Thankz ---(end

Re: [GENERAL] Checking cursor's state in plpgsql

thankz :-) On 4/10/05, Bruce Momjian wrote: > Sibtay Abbas wrote: > > Hello all > > > > Can we check whether a cursor is OPEN or not in plpgsql. > > Like in oracle you can check a CURSOR'S state with %ISOPEN > > > No, but we do have a TODO item: >

[GENERAL] working with multidimensional arrays in plpgsql

hello everyone i am having problem with multidimensional arrays in plpgsql following is the source code of the function which i am trying to run CREATE OR REPLACE FUNCTION test() RETURNS VOID AS $$ DECLARE x INTEGER[10][10]; tmp VARCHAR(40); BEGIN x[3][1] := '20'; --i have even

Re: [GENERAL] working with multidimensional arrays in plpgsql

On Wed, 26 Jan 2005 12:40:24 +0500, Sibtay Abbas <[EMAIL PROTECTED]> wrote: > hello everyone > > i am having problem with multidimensional arrays in plpgsql following > is the source code of the function which i am trying to run > > CREATE OR REPLACE FUNCTION test() RETU

Re: [GENERAL] Problem with NOT IN and Sub-Select

Add "NOT NULL" keyword in the WHERE clause of your SUB SELECT statement something like that ..NOT IN ( SELECT contact_id FROM tb_contact_role WHERE type2 <> 72 AND type2 NOT NULL) On Wed, 26 Jan 2005 15:03:17 +, mike <[EMAIL PROTECTED]> wrote: > I have the following query > > SE

[GENERAL] parameters handling in postgresql functions

hi all How are function parameters generally passed in postgresql. More specifically when we pass a variable to a plpgsql function is passed by value or by reference Thank You ---(end of broadcast)--- TIP 2: you can get off all lists at once with t