could be
> table1... table2.pk2
> table1... NULL
> Doable?
Yes.
SELECT table1.*, table2.pk2
FROM table1 LEFT OUTER JOIN table2 ON (table1.pk1 = table2.pk2);
HTH :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100cell: +1 415
_order (
issuer VARCHAR(255) NOT NULL
, mo_num VARCHAR(64) NOT NULL
) INHERITS (payment);
CREATE TABLE payment_wire (
payment_wire_desc VARCHAR(255) NOT NULL
) INHERITS (payment);
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.
FROM
generate_series(0,'2005-02-01'::date - '2005-01-01'::date - 1) AS s(i);
LEFT JOIN
your_table t
ON
('2005-01-01'::date + s.i = t.your_date_col);
You can also use generate_series() with a correllated subquery so as
not to have to hard-code dates.
HT
be done in a container-independent way (*shudder*). I'm quite sure
> that using EJB timers is NOT the right way to do it - they're not
> supported by web profile containers and are really intended for
> "business level" timers that should be persistent across
> rede