Hi there,
I'm trying to implement a "versionned" storage for a datawarehouse
system, meaning I have tables which store daily information about
objects and I would like to have a row inserted (i.e. a new version)
only if it differs from the most recent existing row. For instance
instead of storin
> So my question is: is there a way to do some kind of whole-row
> comparison ? For instance a hash of the full row or something similar ?
> Is there a standard way of solving this problem ?
Sure it is called row wise comparison:
http://www.postgresql.org/docs/8.2/interactive/functions-comparisons
--- [EMAIL PROTECTED] wrote:
> select * from temp."BSC_Table" t, public.bsc_view p where t.id = p.id
> and row(t) <> row(p);
>
> ERROR: operator does not exist: "temp"."BSC_Table" <> bsc_view
> SQL state: 42883
> Hint: No operator matches the given name and argument type(s). You may
> need to add
Ok I understand now that this row(t.*) syntax is new to postgres 8.2
As explained in the documentation, ยง4.2.11. Row Constructors:
A row constructor can include the syntax rowvalue.*, which will be expanded to
a list of the elements of the row value, just as occurs when the .* syntax is
used a
