[SQL]

2005-03-20 Thread Octavio Alvarez
31 34 25 So I can get the stddev and stuff from the "duration" of the items. I've been having a hard time with it. I'm trying NOT to program new functions. Any help will be appreciated. --Octavio -- Ing. Octavio Alvarez Piza, Jefe de Informática, TBC Universidad. Tel.

Re: [SQL] [PERFORM] Seq scan on zero-parameters function

2004-02-06 Thread Octavio Alvarez
Tomasz Myrta said: > Dnia 2004-02-06 09:43, U¿ytkownik Octavio Alvarez napisa³: >> Thanks for the hint. >> >> In fact, my current_period_id() is based on time, but it should be >> constant along the query execution. I mean, I don't want some records >> fi

Re: [SQL] LEFT JOIN on one and/or another column (thanks)

2004-01-29 Thread Octavio Alvarez
that task, like assigning a different task, or moving it to another moment, and the query I'm trying to make should answer what tasks should be done now. Thank you. Bruno Wolff III said: > On Wed, Jan 28, 2004 at 20:27:00 -0800, > Octavio Alvarez <[EMAIL PROTECTED]> wrote: &

[SQL] LEFT JOIN on one and/or another column

2004-01-28 Thread Octavio Alvarez
references a different table, one with typical data, and one with exception data. I'd like to join on the original, except when exception <> NULL, but I can't quite figure out how to do so. Can anyone help? Thanks you. :-) Octavio. -- Octavio Alvarez. E-mail: [EMAIL PROTECTED] A