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

From Enver ALTIN
Subject Re: How do i store arbitrary questions and answers in SQL?
Date
Msg-id 20060823131323.GB8476@golf
Whole thread Raw
In response to How do i store arbitrary questions and answers in SQL?  ("lifeisgood" <paul1brian@gmail.com>)
Responses Re: How do i store arbitrary questions and answers in SQL?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Hi,

On Wed, Aug 23, 2006 at 02:40:29AM -0700, lifeisgood 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.

-HTH
--
Enver

Attachment

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [8.1.4] Create index on timestamp fails
Next
From: "Dave Page"
Date:
Subject: Re: What's special about 1916-10-01 02:25:20? Odd jump in internal timestamptz representation