[SQL] Altering pg_conndefaults

2001-08-19 Thread macky
how do i change the User in pg_conndefaults because the user is not valid to connect to DB. one thing i can do is to add the User but is there a way to change the user seen in pg_conndeafaults... thanks in advance

Re: [SQL] Array in plpgsql

2001-08-19 Thread Christopher Sawtell
On Mon, 20 Aug 2001 08:41, omid omoomi wrote: > hi all, > Can some body show me how to declare a variable of type "array" in a > function using plpgsql ? http://www.postgresql.org/idocs/index.php?non-atomic-values.html#AEN1244 -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021

[SQL] Array in plpgsql

2001-08-19 Thread omid omoomi
hi all, Can some body show me how to declare a variable of type "array" in a function using plpgsql ? TIA Omid Omoomi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ---(end of

[SQL] Re: how to use record type

2001-08-19 Thread Horst Herb
On Saturday 18 August 2001 00:18, you wrote: > I have encountered this problem (in a different context), and could not > find a way to insert entire rows/records in the way that you appear to > want. But it worked fine if I INSERTed explicitly, like: > INSERT INTO table VALUES (OLD.field1, OLD.fi