Hello, I have some problem with enum of postgres.
Next code works fine (my_type is enum type ({'one', 'two'}) in database):
std::string my_type;
try
{
sql << "SELECT my_type "
"FROM cheme1.test_table "
"WHERE id = :id ",
soci::into(my_type),
soci::use(302);
}
catch (soci::postgresql_soci_error const& e) {
std::cerr << "PostgreSQL error: " << e.what() << std::endl;
}
std::cout << my_type;
output:
one
It's ok.
BUT if I try next code:
try
{
soci::rowset<soci::row> rows = (sql.prepare << "SELECT my_type FROM
cheme1.test_table");
for (const auto& row_item: rows) {
(void)row_item;
}
}
catch (soci::postgresql_soci_error const & e) {
std::cerr << "PostgreSQL error: " << e.what() << std::endl;
}
OR (with type_conversion):
struct info
{
boost::int64_t _id;
std::string _my_type;
};
// template<> struct type_conversion<info> {...}
soci::rowset<info> rows = (sql.prepare << "SELECT id, my_type FROM
cheme1.test_table");
I've an assertion:
terminate called after throwing an instance of 'soci::soci_error'
what(): Unknown data type.
What am I doing wrong? Please help me and very thanks!
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
