From: Adriaan Joubert <a.joubert@albourne.com>
To: pgsql-sql@postgresql.org
Subject: CAST issue/ecpg
Date: Mon, 18 Jun 2001 11:06:40 +0300
Message-ID: <3B2DB690.A646A3B1@albourne.com> (raw)
Hi,
I've hit a slightly annoying issue with casts and inidicators. Due to
problems using constant INT8's in queries (no <= for float and int8), I
put a cast around all INT8 values. This gives me e.g.
EXEC SQL INSERT INTO stats
(stats_id, obj_id, stats_time, stats_val, stats_par,
snap_time)
VALUES
(:stats_id, :obj_id, CAST (:stats_time AS BIGINT ),
:stats_val,
:stats_par, CAST (:snap_time AS BIGINT ) :i_snap_time);
ecpg does not like a CAST with an indicator after it, and dies with a
parse error. Without an inidicator variable it seems happy.
Adriaan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: a.joubert@albourne.com
Subject: Re: CAST issue/ecpg
In-Reply-To: <3B2DB690.A646A3B1@albourne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox