[BUGS] socket error while creating database in windows98

2004-02-12 Thread Sh A Guru Prasad
We have installed beta version of postgres 7.2.1 on windows98. Initdb went through. while createing c:\>pgsql>creatdb sample following error message is being displayed psql.exe: cound not connect to server: socket error, No decription available (0X274D) is the server running on host lo

[BUGS] substring problem

2003-12-31 Thread Sh A Guru Prasad
select trn_id,substr(hoa_id,1,13) from tbill_master where substr(hoa _id,1,13)='2202031040006'; trn_id |substr +--- 25001203000416 | 2202031040006 25001203000417 | 2202031040006 25001203000418 | 2202031040006 25001203000419 | 2202031040006 250012030

[BUGS] (none)

2003-12-30 Thread Sh A Guru Prasad
Hi, How to convert number format (with decimal) into integer only ex:to conver 100.00 to 100. One more Do we have any code to convert number to words ex: 1234 to one thousand two hundredn and thirty four. (I want to use for indian currency only, i will use crores instead of billions) Thank you

[BUGS] decimal to integer, number to words

2003-12-30 Thread Sh A Guru Prasad
Hi, How to convert number format (with decimal) into integer only ex:to conver 100.00 to 100. One more Do we have any code to convert number to words ex: 1234 to one thousand two hundredn and thirty four. (I want to use for indian currency only, i will use crores instead of billions) Thank you

[BUGS] date validation problem

2003-12-29 Thread Sh A Guru Prasad
sir, in postgresql 7.3.2 when we are trying to query like select to_date('66555','ddmm'); the output is 5559-09-06 it is not validating the day and month and unknown format is the output.. any help regarding this is greatful... thank you ---(end of b

[BUGS] pg_connect() problem

2003-12-22 Thread Sh A Guru Prasad
After upgrading postgres from 7.1 to 7.3.2 PHP 4.0.6 was working fine but after upgrading PHP from 4.0.6 to 4.3.2 version it was unable to connect to database as pg_connect() was not working. bye guru ---(end of broadcast)--- TIP 8: explai

[BUGS] installation problem

2003-12-08 Thread Sh A Guru Prasad
I am finding it difficult to install postgresql7.3.2 on linux advanced server. Repeatedly its asking for some or other files. Please let me know the exact procedure and what are the dependency files required for the same. bye guruprasad ---(end of broadcast)--