Re: Syntax error in spi_prepare usage

[dipti shah <shahdipti1980@xxxxxxxxx>]

Thanks a lot Alban. That was simple!

On Sat, Apr 24, 2010 at 10:15 PM, Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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!