Search results for query: *

I have a query in which I need to find all the rows with a specific column being null. Ex: select count(*) from proposal_review_info where reviewerid='xyz' and status=1 and review_result=''; the above query does not work. What is the correct solution for the above query?

Hi, In my table I have a primary key column proposaid which will take values like x6a1 x6a2 . . . x6a10 . . In order to insert a unique proposalid (kind of auto increment but with varchar type), I was doing select max(proposalid) from proposalinfo; But now I found that once proposalid reaches...

Hi, I have a table which has 3 fields. reviewerid varchar(20), proposalid varchar(20), dt timestamp without time zone I would like to know how I can select proposalid's belonging to a particular reviewerid for the span of 12 months? Is it possible to get the difference in dates when it;s a...

Hi, this is a stupid question but still I am curious to know. when I alter the table for adding an additional column to the table, can I add the column into a specific position? Say I have columns a varchar(20) b integer d boolean If I add a column c varchar(20) can I add after column b ? By...

Hi, I have 2 questions. 1. I need to define a column in one of my postgresql table. This column can have integer values from 1-999. Which is the best datatype, varchar or smallint?Considering the disk space occupied. 2. Is it possible to have custom built value for a column of type SERIAL. For...