Re: [GENERAL] problem with floats

1998-06-23 Thread mmaruska
> I was trying to use some c code to return floats to postgres but I keep > getting the following error : > > template1=> select oner(); > PQexec() -- Request was sent to backend, but backend closed the channel before > responding. This probably means the backend terminate

Re: [GENERAL] problem with floats

1998-06-23 Thread Alex Carobus
Sorry, I forgot to mention that the program works when all the float8's are replaced by int4's. Any other ideas? -Alex > > I was trying to use some c code to return floats to postgres but I keep > > getting the following error : > > > > template1=> select oner(); > > PQexe

Re: [GENERAL] problem with floats

1998-06-23 Thread Bruce Tong
> I was trying to use some c code to return floats to postgres but I keep > getting the following error : > > template1=> select oner(); > PQexec() -- Request was sent to backend, but backend closed the channel before > responding. This probably means the backend terminated

Re: [GENERAL] datatype questions

1998-06-23 Thread Peter Mount
On Mon, 22 Jun 1998, Brian wrote: > I am trying to convert a table into PostgresSQL from MySQL, and had a few > questions: [snip] > 2. Does postgres support anything even like a "blob" data type? yes and no. I posted an experimental blob type (actually its lo) just over a week ago, and it shou

Re: [GENERAL] Q: How to convert int to date?

1998-06-23 Thread Patrice Hédé
On Tue, 23 Jun 1998, Mattias Kregert wrote: > How do I convert INTEGER to DATE in 6.3.2? > > I have a table 'mytbl' with a column 'd' which is > an integer, containing dates in YYMMDD form. Now, > how do I convert these integer dates to date dates? > > I tried... > ALTER TABLE mytbl ADD COLUM

Re: [GENERAL] Q: How to convert int to date?

1998-06-23 Thread Patrice Hédé
On Tue, 23 Jun 1998, Mattias Kregert wrote: > How do I convert INTEGER to DATE in 6.3.2? > > I have a table 'mytbl' with a column 'd' which is > an integer, containing dates in YYMMDD form. Now, > how do I convert these integer dates to date dates? I tried to do : test=> SELECT 980623::text::d

[GENERAL] Looking for a CASE tool that will normalize databases.

1998-06-23 Thread Peter Cordone
I am new to database programming and PostgreSQL, so bear with me if this sounds nieve. Is there a CASE tool that will run on Linux that will automate normalizing databases (that is put them in first normal form, and second normal form, etc)?

[GENERAL] Re: [ADMIN] User authetication failed.

1998-06-23 Thread Bruce Tong
> while connecting to Postmaster from network through psql it fails on > user autetication. > can somebody tell me what I can do to get connected. > > Any quick help will be highly appreciated. What have you specified in your pg_hba.conf file? Bruce Tong | Got me an office

Re: [GENERAL] Q: How to convert int to date?

1998-06-23 Thread Marin D
On Tue, 23 Jun 1998, Mattias Kregert wrote: ->How do I convert INTEGER to DATE in 6.3.2? -> ->I have a table 'mytbl' with a column 'd' which is ->an integer, containing dates in YYMMDD form. Now, This is quite bad representation of date. U know Y2K, so on... ->how do I convert these integer

[GENERAL] Q: How to convert int to date?

1998-06-23 Thread Mattias Kregert
How do I convert INTEGER to DATE in 6.3.2? I have a table 'mytbl' with a column 'd' which is an integer, containing dates in YYMMDD form. Now, how do I convert these integer dates to date dates? I tried... ALTER TABLE mytbl ADD COLUMN dd date; UPDATE mytbl SET dd=date(d+1900); ...but there i

[GENERAL] User authetication failed.

1998-06-23 Thread Naushit Sakarvadia
Hello all My problem is: while connecting to Postmaster from network through psql it fails on user autetication. can somebody tell me what I can do to get connected. Any quick help will be highly appreciated. Regards, Naushit P.S Please write me on my email as I am not regular subriber