help help !!

From: yogesh(at)ncbs(dot)tifrbng(dot)res(dot)in (Yogesh Bhanu)
To: pgsql-admin(at)postgreSQL(dot)org
Subject: help help !!
Date: 1998-06-22 06:53:21
Message-ID: 199806220653.GAA29723@ncbs.tifrbng.res.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi
I have a library db which uses it own s/w Libsys which stores data in a
flat file.Now I am thinking of porting the same to Postgres.I have couple
of problems .As the s/w is proprietry .I don't how the data is stored .
in fact the flat file shows a big chunk of ASCII & control characters.
So the task of interpreting the flat file is difficult.The s/w runs on
Win 3.1(it is a 16bit app).
Can anyone tell me how do I attack the Problem.
Some time back I had posted a query but did'nt get a reply for it
it is regarding Passing query through cgi.I wanted some Docs on
how to embed Sql query inside Perl.
Is there a way I can do input formatting in sql .
My problem is this
I have my name Col entered as First char Caps and if the user types in any otherformat it Bombs here is an Ex:

phone=> select * from phonebook where name = 'yogesh';
name|phone_nr|desig
----+--------+-----
(0 rows)

phone=> select * from phonebook where name = 'Yogesh';
name |phone_nr|desig
------+--------+-----
Yogesh| 359|Tra

Thanx in advance
yogesh

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Heflin 1998-06-23 00:03:08 moving databases
Previous Message Enrico Cantu 1998-06-22 03:03:59 spam