On 23 Apr 2010, at 13:17, dipti shah wrote:
For this case you're using 3 values in the first half of the expression and only 1 in the second:
> techdb=# INSERT INTO changelogtest (id, txid, txtime)
> values (5, 123, 'now')
^^ ^^^ ^^^^--- 3 columns, namely int, int & text.
> except
> select (id, txid, txtime)
^^^^^^^^^^^^^^^^^^^--- 1 column, a row-type containing (int, int, timestamp)
> from changelogtest
> where id=5;
> ERROR: each EXCEPT query must have the same number of columns
> LINE 2: except select (id, txid, txtime)
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4bd18a9110411947912088!