convert with libpq - Mailing list pgsql-sql

From lms
Subject convert with libpq
Date
Msg-id 20061116194623.M54721@isb.com.pl
Whole thread Raw
List pgsql-sql
Hi

I must convert some records from database. 
I have table named "langset" in unicode database. When I try use command 

select convert((SELECT "1" from langset where id_langset=5) using 
utf_8_to_iso_8859_2)

in PGadmin, all is ok, sql return 1 record. But where i execute the same 
command in libpq I got 0 rows:
res=PQexec(conn_lokalne,"select convert((SELECT \"1\" from langset where 
id_langset=5) using utf_8_to_iso_8859_2)");

printf("%s",PQgetvalue(res,0,0));

What is the problem?



pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Random()
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Re: Random()