> On 7/16/04 11:11 AM, "Edmund Bacon" <ebacon(at)onesystem(dot)com> wrote:
>>Indicators works as expected. e.g.:
>>EXEC SQL INSERT INTO sometable
>> VALUES (:v1 :v1_ind, 'foo', :v2 :v2_ind);
> Hmm. I tried that. Just tried it again and it worked. Must have had a
> typo before. Sorry.
> What about if I have something like:
> ... VALUES (TO_TIMESTAMP(:expirationDate, 'YYYYMMDDHH24MISS'), 'foo', :v2)
> How can I insert NULLS for expirationDate when there's a function in the
> way? Using
> ... VALUES (TO_TIMESTAMP(:expirationDate, 'YYYYMMDDHH24MISS') :ind1, ...
> won't work.
... VALUES (TO_TIMESTAMP(:expirationDate :ind1, 'YYYYMMDDHH24MISS'), ..
Edmund Bacon <ebacon(at)onesystem(dot)com>
In response to
pgsql-interfaces by date
|Next:||From: miguel lam||Date: 2004-07-16 20:11:21|
|Subject: C++ Procedural Language or something like this|
|Previous:||From: wespvp||Date: 2004-07-16 16:25:59|
|Subject: Re: NULLs in ecpg|