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

[Albert Chen]

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 have others, thanks.

-Albert.

__
Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] Date convertion problem.

[Albert Chen]

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 at http://www.hotmail.com

[GENERAL] Does Apache has PostgreSQL module?

[Albert Chen]

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

[Albert Chen]

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.

-Albert


__
Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] Cannot compile JDBC.

[Albert Chen]

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;
   ^
postgresql/Connection.java:8: Package postgresql.fastpath not found in 
import.
import postgresql.fastpath.*;
  ^
postgresql/Connection.java:9: Package postgresql.largeobject not found in 
import .
import postgresql.largeobject.*;
   ^
postgresql/Connection.java:10: Package postgresql.util not found in import.
import postgresql.util.*;
  ^
4 errors
make: *** [postgresql/Connection.class] Error 1

Would anyone help me how to solve the problem, thanks.

-Albert


__
Get Your Private, Free Email at http://www.hotmail.com

[GENERAL] Query buffer problem.

[Albert Chen]

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 length of 2 exceeded
query line ignored
Segmentation fault (core dumped)


Would anyone know how to solve this problem, thanks in advance.

-Albert


__
Get Your Private, Free Email at http://www.hotmail.com