Re: [SQL] handling money type

2005-10-27 Thread codeWarrior
The SQL data type "money" in postgreSQL was deprecated several versions ago... however -- it is still available in the system. The definitions is: CREATE TYPE money (INPUT=cash_in, OUTPUT=cash_out, DEFAULT='', INTERNALLENGTH=4, ALIGNMENT=int4, STORAGE=PLAIN); ALTER TYPE money OWNER TO p

Re: [SQL] handling money type

2005-10-27 Thread Richard Huxton
padmanabha konkodi wrote: hello developers, i have facing one major problem handling sql money dataType in the java i have tried many permutation and combination but still i dint got correct data type to use in java to pass money data Have you tried PG's "numeric" type? What problems did you

[SQL] handling money type

2005-10-26 Thread padmanabha konkodi
hello developers, i have facing one major problem handling sql money dataType in the java i have tried many permutation and combination but still i dint got correct data type to use in java to pass money data