Is there a problem with DNS? a few hours ago, www.fr.postgresql.org was
not defined, now that it works again, ftp.fr.postgresql.org dosn't exist

Hm, here's a query where the optimizer is choosing the wrong plan by far. I
think it boils down to it guessing wrong on how selective an rtree index is,
which I guess would be hard to predict.
Except if it guesses wrong by assuming it isn't selective it would be maybe

I have had a lot of problems trying to install the postgres on a second
FreeBSD box. I installed it using the ports install, so that part of the
process went painlessly. however, when I tried to run the .sh script file
that was installed, I get nothing. The script's commands are:

I need to add a large number(1000) records to my table. How would I do this
using a file? Any help is greatly appreciated.
Kelly
---------------------------(end of broadcast)---------------------------

If I give psql the -A option, does it still wait for all the data to come in before
starting output?

I noticed that some date are not anymore accepted:
Postgres 7.3.3:
test=# select '18/03/71'::date;
   date    

I'm playing with SETOF on functions.  But I can't get the return type
correct.  What have I missed?  A cast?
CREATE OR REPLACE FUNCTION elementGet (text) RETURNS SETOF
element_type AS '

I have had two times problem with pg database corruption.
My system:
Dual athlon 2.4
1 GB RAM,

============================================================================
                       POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name        :    Karthik S

Following is from Documentation/vm/overcommit-accounting
-------------
2    -    (NEW) strict overcommit. The total address space commit
        for the system is not permitted to exceed swap + a

       I start postgresql with "/app/pgsql/bin/pg_ctl start -l /app/pgsql/logfile -D /app/pgsql/data",
when I use "cat /dev/null > /app/pgsql/logile" to clear logfile, I can't clear logfile. How can I
clear the logfile, thank you!
vincent

Is it posible to define a function with no return value?
I've something like "CREATE FUNCTION set_to_active(int4) RETURNS NULL AS
..." but I get an parse error at or near "NULL"
Thanks,

Dear Sir:
        I have tried to  create a new Type in  postgreSQL-7.2. The
example is defined in Chapter 39 of extended type. We  do follow your
defination  of "Complex" completely.But there is always an error:

How do I view the arguments and details of a user defined function?

Question,
I have a table (1) with 2 col (a & b) where b can sometimes be null.  I need a query that if B is null I get back the contents of A.. but if B is not null I do a join on it and table (2) col c to get the contents of table (2) col d..   I can do this in multiple queries.. ...