PQexec(), what should I do for the "NULL in command" problem?

Поиск
Список
Период
Сортировка
От jason
Тема PQexec(), what should I do for the "NULL in command" problem?
Дата
Msg-id 1194575963.723752.5830@v29g2000prd.googlegroups.com
обсуждение исходный текст
Ответы Re: PQexec(), what should I do for the "NULL in command" problem?
Список pgsql-general
Hello:

As you know the interface of PQexec():
PGresult *PQexec(PGconn *conn, const char *command);

"command" contains  some SQL statements.

But there exist "\0" in some data filed, and I found PQexec() failed
on such situation.
Something like this:

PQexec(conn, "INSERT INTO tttt('ttttt', 'abc\0abc');


Does anyone know something about this?
How can I insert a record which has some NULLs in data filed?


Best Regards,
Jason


В списке pgsql-general по дате отправления:

Предыдущее
От: Gordon
Дата:
Сообщение: Duplicating a table row while honouring key constraints
Следующее
От: Mark Niedzielski
Дата:
Сообщение: Linux v.s. Mac OS-X Performance