Re: NULLs in ecpg - Mailing list pgsql-interfaces

From Edmund Bacon
Subject Re: NULLs in ecpg
Date
Msg-id 40F7FE1A.8010001@onesystem.com
Whole thread Raw
In response to NULLs in ecpg  (<wespvp@syntegra.com>)
Responses Re: NULLs in ecpg
List pgsql-interfaces
wespvp@syntegra.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@onesystem.com>


pgsql-interfaces by date:

Previous
From:
Date:
Subject: NULLs in ecpg
Next
From:
Date:
Subject: Re: NULLs in ecpg