Retrieving values from tables

[makhan]

Hi

I am using my c based application using libpq to connect to postgresql. I have a table called light. I want to collect the values of the table light into a varible condition so that I can check this condition if(condition ==3) and do some operation depending on this operation.

Can someone guide me how this can be done.

Regards
MAK

[michaelb]

Did you try to build SQL with SELECT statement and the WHERE clause?

These examples may help you:

http://www.postgresql.org/docs/8.1/static/sql-select.html

http://www.postgresql.org/docs/8.1/static/libpq-example.html

http://www.postgresql.org/docs/8.1/interactive/libpq-exec.html