I got sum(money attribute) to return 0.00 instead of NULL when there
are zero tuples in class, by redefining the sum() aggregate to set
initcond1 to 0.00. Perhaps you do something similar with your AVL().
-- Replace existing sum(money) to return $0.00
-- for zero instances
drop a
Hi, I am considering utilizing Postgresql for a rather intensive web
project on an Irix 6.2 box. I have had quite good results with
postgresql on Linux, but, having perused the mailing lists and
dejanews, I see that there are maybe some weirdnesses on Irix. I'm
curious if anyone else out there i
I am writing a program to interface with the pgsql backend in c on a
linux box.
When I try to connect, it gives me the following error message:
Failed to authenticate client as Postgres user 'root' using :be_recvauth: unrecognized message type: 65536
I think maybe I should use the fe_setauthsvc
Hi,
I compiled JDBC sources , that comes with version 6.3 .
When I am trying to connect to data base ,
"DriverManager.getConnection("jdbc:postgresql://haver:5432/natali",
"natali", "Elina);"
I got a response:
>
> java.sql.SQLException: User authentication failed
> at java.lang.T
Did you link in crypt? Try adding -lcrypt to the compile line.
-DEJ
> -Original Message-
> From: Matthew [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 12, 1998 10:50 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] crypt compile error
>
> Hello, I am new to the wor
Hello, I am new to the world of PostgreSQL. I recently installed the
PostgreSQL database and tried to compile one of the example C programs
from the web site. I fixed a few typo's then it compiled, but when it
goes to do the linking I get an error complaining about undefined
reference to crypt.
Hi all,
I'm looking for a function like COALESCE() or the Oracle NVL(),
to returns a ZERO value instead of a NULL value.
To have the result: NULL+1 = 1 instead of NULL+1 = NULL
Have PostgreSQL something like this ?
I tried to write it on C but I can't realize the beavior of NULLs,
I can't get tha
