Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: uniware
- Order by date
-
Null query not working
I think your usage is not right. Judge whether a field is null or not should use: SELECT * FROM users WHERE user_id IS NULL- uniware
- Post #2
- Forum: PostgreSQL Inc.: PostgreSQL
-
Parser error, why?
What's your PostgreSQL's version? You may get it from psql using 'select version()'. In 7.3 I find there are no data type called DATETIME, use TIMESTAMP instead. Another thing is that you should use := to do assignment of variables. 'SELECT col INTO var' should be used to assign select...- uniware
- Post #6
- Forum: PostgreSQL Inc.: PostgreSQL
-
PostgreSQL with Windows
Cygwin + PostgreSQL works well. But you may pay some attention to the performance. I have used PostgreSQL 7.3 on Cygwin on a Windows 2000 box.- uniware
- Post #4
- Forum: -General database discussion
-
rule _RETURN question
As far as I know, any rules named as '_RETURN' is defined by system when you create a view. So you don't need worry about rules named '_RETURN'. As a fast check, you can try to defined a rule named '_RETURN', postgresql will issue an error message.- uniware
- Post #5
- Forum: PostgreSQL Inc.: PostgreSQL
