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
>> filtered with some values and other with othe
At some point in time, [EMAIL PROTECTED] (Google Mike) wrote:
>Create a priority column in a test table and add the entries, "HI",
>"N", and "LO" in sequence like that for up to, say, 15 rows. Now
>select this and order by priority. You'll notice that it goes in "HI",
>"LO", and "N" order. A more
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Dnia 2004-02-06 12:38, Użytkownik Gary Stainburn napisał:
Hi folks,
I've got an accounts table and a transactions table and want to do a summary
join. If I do:
bank=# select aid, aname, aodraft from accounts a
bank-# left outer join (select account, sum(amount) as balance
bank(# from statement
Hi folks,
I've got an accounts table and a transactions table and want to do a summary
join. If I do:
bank=# select aid, aname, aodraft from accounts a
bank-# left outer join (select account, sum(amount) as balance
bank(# from statement group by account) as s
bank-# on s.account = a.aid;
I get
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
filtered with some values and other with other values... I'll have an
uncongruent
Dnia 2004-02-06 08:19, Użytkownik Octavio Alvarez napisał:
Hi!
I'd like to know if this is expected behavior. These are two couples of
queries. In each couple, the first one has a WHERE field = function()
condition, just like the second one, but in the form WHERE field =
(SELECT function()). In
