From: Matthew Denny <mdenny@CS.Berkeley.EDU>
To: pgsql-interfaces@postgresql.org
To: pgsql-novice@postgresql.org
Subject: a couple of newbie question
Date: Sun, 16 Apr 2000 11:57:38 -0700 (PDT)
Message-ID: <14586.1494.348246.364700@caracas.CS.Berkeley.EDU> (raw)
I know this question is probably fairly elementary, but I could not
find the answer in the docs or mailing list archives. How does one handle
NULL values in the embedded SQL interface? For example, if I have a
statement:
exec sql insert into test_table values(:foo, :x, :y)
and foo represents a CHAR attribute (represented by a string in C) that I
want to set to NULL, how do I go about doing this? Similarly, how do
I tell that a value put into a variable by a fetch call is NULL or
not?
On a different note, is there any list of error codes for the actual
postgreSQL errors, or is the only thing a user can get back is the
text message in sqlca.sqlerrm.sqlerrmc (e.g. no associated error #)?
Any help would be greatly appreciated.
thanks,
Matt
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-interfaces@postgresql.org
Cc: mdenny@CS.Berkeley.EDU, pgsql-novice@postgresql.org
Subject: Re: a couple of newbie question
In-Reply-To: <14586.1494.348246.364700@caracas.CS.Berkeley.EDU>
* 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