Hi
Given the sql below shouldn't I get the 3 records back?
create table t1 (attribute text);
insert into t1 values ('cars');
insert into t1 values ('trucks');
insert into t1 values ('bikes');
create table t2 (id serial, category text, attribute text, val integer);
insert into t2(category, attri
Thanks Tom I can confirm this passed in 8.4.1
Tom Lane wrote:
Angus Miller writes:
Given the sql below shouldn't I get the 3 records back?
Try 8.4.1 --- I think you got bit by the semijoin ordering bugs in
8.4.0.
regards, tom lane
--
Sent via
I couldn't resist... http://bit.ly/aks7og
Hi
I have a table that models data in a temporal fashion. I say temporal
fashion as I'm not sure I got this 100% right buy here goes. Basically
each record has a date_from and date_to column. The date_from column
always defaults to the current system date. The date_to column is
either a far future
Thanks Sergery that's what I was after.
1 2010/01/01
On Mon, Sep 6, 2010 at 2:29 PM, Sergey Konoplev wrote:
> Hi,
>
> On 6 September 2010 16:18, Angus Miller wrote:
>> How can I generate result-set that will carry the previous records
>> values through till a new ev
