[SQL] Performance Problems

2002-12-12 Thread Héctor Iturre
Hi, Thanks, i fix the problem, it was the linux configuration. Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/sms.html ---(end of broadcast)--- TIP 2: you can get off all lis

Re: [SQL] Stored Procedure Problem

2002-12-12 Thread Héctor Iturre
Hi, use this CREATE FUNCTION b_function() RETURNS int4 AS ' DECLARE an_integer int4; BEGIN select into an_integer emp_id from employee; return an_integer; END; ' LANGUAGE 'plpgsql'; --- Atul <[EMAIL PROTECTED]> escribió: > Hello, > > Atul Here, I have one

[SQL] Performance Problems

2002-12-12 Thread Héctor Iturre
Hi, I have performance problems with a huge database (there a 2 tables with 40 millions of records) and many users doing updates and queries on it. I 've perform severals VACUMM on the database with poor results. Each table have an unique index and I added other indexes to improve the perfor

[SQL] ISNULL FUNCTION

2002-12-09 Thread Héctor Iturre
HI, HERE IS AN ALTERNATIVE TO USE THE SQL SERVER ISNULL() FUNCTION select case when FIELD_NAME isnull then 'EXPRESION' else FIELD_NAME end from calfiscal where impuesto = 1 Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/s

[SQL] ISNULL FUNCTION

2002-12-09 Thread Héctor Iturre
HI, HERE IS AN ALTERNATIVE TO USE THE SQL SERVER ISNULL() FUNCTION select case when FIELD_NAME isnull then 'EXPRESION' else FIELD_NAME end from calfiscal where impuesto = 1 Ahora podés usar Yahoo! Messenger desde tu celular. Aprendé cómo hacerlo en Yahoo! Móvil: http://ar.mobile.yahoo.com/s