Re: [SQL] How can this INSERT fail?

2012-04-25 Thread Abbas
Which version of postgresql it is ? Best Regards, Abbas On Wed, Apr 25, 2012 at 5:15 PM, Peter Harris wrote: > I'm trying to INSERT into a table, avoiding duplicates, using this sort of > thing: > -- -- > insert into buddyinvite (bi_user, bi_invited) > select 'a&#x

Re: [SQL] backup

2009-06-09 Thread Abbas
*from test where a<6) to 'C:/Program Files/PostgreSQL/8.3/data/samp.sql'; COPY 9 Thanks, Abbas EnterpriseDB > > -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto: > pgsql-sql-ow...@postgresql.org] > On Behalf Of Jasen Betts > Sent: Tuesd

Re: [SQL] working with multidimensional arrays in plpgsql

2005-01-26 Thread Sibtay Abbas
thank you very much for your reply I did as you specified and it worked fine thankz :) On Wed, 26 Jan 2005 09:29:53 +, Richard Huxton wrote: > Sibtay Abbas wrote: > > hello everyone > > > > i am having problem with multidimensional arrays in plpgsql following > >

[SQL] working with multidimensional arrays in plpgsql

2005-01-25 Thread Sibtay Abbas
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