Thanks a lot Alban. That was simple!
On Sat, Apr 24, 2010 at 10:15 PM, Alban Hertroys
<dalroi@solfertje.student.utwente.nl> wrote:
> If I remove the braces from (\$1, \$2, \$3) then it gives below error.
>
> my $query = (<<ENDQUERY);
> INSERT INTO changelogtest(id, txid, txtime)
> SELECT \$1, \$2, \$3
> EXCEPT
> SELECT (id, txid, txtime)
> FROM changelogtest
> WHERE id = \$1
> AND txid = \$2
> AND txtime = \$3;
> ENDQUERY
>
> techdb=# SELECT insert_history_info();
> ERROR: error from Perl function "insert_history_info": each EXCEPT query must have the same number of columns at line 15.
Yes of course, your select lists are different. Try:
> my $query = (<<ENDQUERY);
> INSERT INTO changelogtest(id, txid, txtime)
> SELECT \$1, \$2, \$3
> EXCEPT
> SELECT id, txid, txtime
> FROM changelogtest
> WHERE id = \$1
> AND txid = \$2
> AND txtime = \$3;
> ENDQUERY
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:1050,4bd3201010417204612880!