Re: NULLs in ecpg

From: Edmund Bacon <ebacon(at)onesystem(dot)com>
To: wespvp(at)syntegra(dot)com
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: NULLs in ecpg
Date: 2004-07-16 16:11:06
Message-ID: 40F7FE1A.8010001@onesystem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

wespvp(at)syntegra(dot)com wrote:
> I couldn't find this in the archives... In an ecpg program, given the
> statement (taken from the manual):
>
> EXEC SQL INSERT INTO sometable VALUES (:v1, 'foo', :v2);

Indicators works as expected. e.g.:

EXEC SQL INSERT INTO sometable
VALUES (:v1 :v1_ind, 'foo', :v2 :v2_ind);

>
> Is there a way to create the record where ':v1' is NULL - as with indicators
> in a FETCH? Or, do I have to generate different SQL statements in the C
> program?
>
> Wes
>

--
Edmund Bacon <ebacon(at)onesystem(dot)com>

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message wespvp 2004-07-16 16:25:59 Re: NULLs in ecpg
Previous Message wespvp 2004-07-16 15:50:43 NULLs in ecpg