Isn't "EXTRACT(dow FROM day) IN (0,6)" always true thus making select
return a row every time?
On 11/10/07, rihad <[EMAIL PROTECTED]> wrote:
>
> I've been reading the online docs, but... code like this somehow ends up
> in an indefinite loop:
>
> CREATE OR REPLACE FUNCTION foo() RETURNS int AS $$
rihad <[EMAIL PROTECTED]> writes:
LOOP
SELECT date+1 INTO day FROM days WHERE date=day OR EXTRACT(dow
FROM day) IN (0,6);
EXIT WHEN NOT FOUND;
timeout := timeout + 86400;
END LOOP;
If the EXTRACT condition is true, then the SELECT will always succeed.
Isn't th
Tom Lane wrote:
rihad <[EMAIL PROTECTED]> writes:
LOOP
SELECT date+1 INTO day FROM days WHERE date=day OR EXTRACT(dow
FROM day) IN (0,6);
EXIT WHEN NOT FOUND;
timeout := timeout + 86400;
END LOOP;
If the EXTRACT condition is true, then the SELECT will always su
rihad <[EMAIL PROTECTED]> writes:
> LOOP
>SELECT date+1 INTO day FROM days WHERE date=day OR EXTRACT(dow
> FROM day) IN (0,6);
>EXIT WHEN NOT FOUND;
>timeout := timeout + 86400;
> END LOOP;
If the EXTRACT condition is true, then the SELECT will always succeed.
Th
I've been reading the online docs, but... code like this somehow ends up
in an indefinite loop:
CREATE OR REPLACE FUNCTION foo() RETURNS int AS $$
DECLARE
timeout int;
day date;
BEGIN
day := current_date + 1;
LOOP
SELECT date+1 INTO day FROM days WHERE date=day OR EXTRACT(dow