who can explain me to declare a blob-field in postgresql ?
- how many blob fields are allowed per table ?
thanks Jens v. Karstedt
Recently we are working on a project that involves storing info about the
user's interests. The user is allowed to choose multiple interests and we
want to be able to query out any users to a specific interest.
Right now there seems to be two ways. Let's assume there are 1000 different
insterests. One way is to have a varchar(1000) or char(1000) field with a
"10101010..."-like string to mark the user interests and we can use
CHARINDEX function for queries. The other way is to use 1000 bit fields. I
would say the latter solution would be faster in executing the queries.
My questions are:
Which scheme do you think is better? Is there any other and more efficient
solutions to achieve this?
Looking forward to your inputs.
4. soap and xml