Re: How do i store arbitrary questions and answers in SQL? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: How do i store arbitrary questions and answers in SQL?
Date
Msg-id 20060823132039.GG5940@merkur.hilbert.loc
Whole thread Raw
In response to Re: How do i store arbitrary questions and answers in SQL?  (Enver ALTIN <ealtin@parkyeri.com>)
List pgsql-general
On Wed, Aug 23, 2006 at 04:13:24PM +0300, Enver ALTIN wrote:

> > CREATE TABLE Answer(ID INT, questionID INT, answer_text VARCHAR(255),
> > datatype INT)
>
> You can actually store answer_text as a BLOB in the database that is
> packed in any format your application can handle. You can serialize a
> class that represents the answer you need and store it, for example.

There was an article on that on Elein's General Bits not too
long ago.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Installation Help needed
Next
From: Karsten Hilbert
Date:
Subject: Re: [8.1.4] Create index on timestamp fails