[GENERAL] abs() does not exists..

2001-06-12 Thread mazzo
Hi all..i'm trying to create a trigger that fires before i insert a value into a column and if the value i insert is negative, it will change it to positive... I was trying with:   create trigger postv before insert on my_table for each row execute procedure abs (column);   But this doesn't s

[GENERAL] Using , instead of . for thousands..

2001-05-10 Thread mazzo
Hi all...i'm converting an access 97 database to pg and i have a little problem...since i'ìm in italythousand use commas as a separator and not dots (eg 1,000 not 1.000)... is there a function to instruct postgresql to use the comma instead of the dot?? I would be very usefull because it would

[GENERAL] Converting from access to pgsql..questions...

2001-04-10 Thread mazzo
First of all, since i'm new to this mailing listHi all..!! My first question.. I have to convert an access 97 database to pgsql...are there any tools to do this?? I checked the website but the link for the tools are not working so i tried to export the tables from access using the ODBC driver.