Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-10 Thread Arash pajoohande
hello all and thank you for your advices On Thu, Jun 9, 2011 at 7:05 PM, Vincent Veyron wrote: > Le mercredi 08 juin 2011 à 14:43 +0430, Arash pajoohande a écrit : > > > and documents must display on web page when corresponding user > > requests occurs. > > I wonder w

[GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-08 Thread Arash pajoohande
hello i have a lot of files in microsoft word format. each file consists of text and images (other text formatting like font is not important). i want to store this documents in Postgresql, and documents must display on web page when corresponding user requests occurs. it seems theres 2 way to do

Re: [GENERAL] what data type to store fixed size integer?

2011-04-11 Thread Arash pajoohande
@Dave On Mon, Apr 11, 2011 at 9:18 PM, David Johnston wrote: > the data type does not need any arithmetic operations (as of > integers). > > > > You arguably do not have a number but simply a string that looks like a > number. Other examples are zip-codes and phone-numbers if you ignore >

[GENERAL] what data type to store fixed size integer?

2011-04-10 Thread Arash pajoohande
hi there I wan to store a 10 digits integer in a column of table. the data type does not need any arithmetic aperations (as of integers). maybe its good to use bigint, but it is Postgres specific and is not part of SQL standards what is the best data type (fastest) to store it? any help would be ap