[GENERAL] Why PostgreSQL is better than other commerial softwares?

Hi, I'm using FreeBSD and PostgreSQL 6.4. I tell my advisor to try PostgreSQL, but he said:"Why PostgreSQL is better than other commercial softwares? If you could give me ten reasons, and I will give it a try." Would anyone tell me what's reason you like Postgres. Because it's free, powerful and

[GENERAL] Date convertion problem.

Hi, I have a problem about date convertion. I insert a value which attribute is date, like this: insert into example values ('19 Mar 1999'); How do I show the date become 1999/3/19? Thanks in advance, Albert. __ Get Your Private, Free Email

[GENERAL] Does Apache has PostgreSQL module?

Hi, I know there is a ApacheMysql module. Has ApachePostgres module? -Albert __ Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] SQL Regular expression

Hi, I want to search my database table named ex, whose the attribute is subject, and list the results that matches the keyword 'electric'. I run the SQL command: SELECT subject FROM ex WHERE subject='*electric*'; Appearently, it doesn't work. Would anyone know how to do, thanks in advance.

[GENERAL] Cannot compile JDBC.

I download PostgreSQL-6.5 and want to compile jdbc, I'm using JDK1.1.7, while running make jdbc1 in /interfaces/jdbc directory, I got the error: postgres% make jdbc1 javac postgresql/Connection.java postgresql/Connection.java:7: Class postgresql.Field not found in import. import postgresql.Field;

[GENERAL] Query buffer problem.

Hi, I insert 10,000 data into PostgreSQL database. I got the problem while inserting: query buffer max length of 2 exceeded query line ignored . query buffer max length of 2 exceeded query line ignored '); PQsendQuery() -- query is too long. Maximum length is 8191 query buffer max len