[SQL] How to store gif or jpeg? Thanks!

2001-04-15 Thread Maurizio Ortolan
Hello! In your opinion, which is the best way to store images (gif o jpg) with PostgreSQL? Where can I find an easy example? Many thanks to all of you! CIAO! MAURIZIO *** ** Happy surfing on THE NET !! ** ** Ciao by

[SQL] How to simulate MEMO data type?Thanks!

2001-04-15 Thread Maurizio Ortolan
Hello! I'm porting a database from MS Access to PostgreSQL. How can I simulate in pgsql the 'MEMO' (up to 65000 chars) data type, which is often used in Access ? Where can I find an easy example? I don't' know if it's important, but I'm using Linux,Apache,Javascript & PHP. ^^^ Many thanks to

[SQL] Error in the date field (with NULL value...).Thanks!

2001-03-30 Thread Maurizio Ortolan
Subject: Importing data from Informix to PostgreSQL. Error in the date field (WITH NULL value) Hello! I'll try to explain my little problem. Well, I have this table create table mytable ( codice char(16) not null, dt_inizio date, dt_finedate, tipo_operaz

[SQL] Error in the date field (with NULL value...).Thanks!

2001-03-30 Thread Maurizio Ortolan
Subject: Importing data from Informix to PostgreSQL. Error in the date field (WITH NULL value) Hello! I'll try to explain my little problem. Well, I have this table create table mytable ( codice char(16) not null, dt_inizio date, dt_finedate, tipo_operaz