pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



Message-ID: <3B2DB690.A646A3B1@albourne.com>
Permalink:  ../3B2DB690.A646A3B1@albourne.com/
Also on:    postgresql.org/message-id/3B2DB690.A646A3B1@albourne.com

 · 

reply

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