[SQL] smallint with postgresql

2003-08-28 Thread Alessandro Depetro
hello folks! I havo to migrate some tables from Informix to Postgresql and I I'm in doubt if I can safely use NUMBER (as suggested for monetary computation in PGSQL guide) as a data type for smallint. TIA and gby Alessandro Depetro -- Coop Service Noncello s.c.a r.l. onlus http://www.mamco

[SQL] smallint with postgresql

2003-08-28 Thread Alessandro Depetro
ooops NUMBER is NUMERIC excuse my french :) alessandro -- Coop Service Noncello s.c.a r.l. onlus http://www.mamcoop.it/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

[SQL] smallfloat with postgresql

2003-08-28 Thread Alessandro Depetro
omputation instead of smallfloat ??? alessandro depetro -- Coop Service Noncello s.c.a r.l. onlus http://www.mamcoop.it/ ---(end of broadcast)--- TIP 8: explain analyze is your friend