text and numeric - Mailing list pgsql-general

From Masse Jacques
Subject text and numeric
Date
Msg-id 0B87317EA62BD211A02A00A0C9DFB7EC9B5EAE@hermes.bordeaux.cemagref.fr
Whole thread Raw
List pgsql-general
Looking for an expert advice :

I have to store in a table records like (param_name, value)with value as
text or numeric.

Has someone experience what will be the "best" solution

a--------------
param_name        value(text)
'length'        30
'color'        green

with type casting on the queries or

b--------------
param_name        value(text)        value(numeric)
'length'                    30
'color'        green

with some function for the choice of the column ?



___________________________________________
Jacques Massé
Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01



pgsql-general by date:

Previous
From: Holger Marzen
Date:
Subject: Re: Update to readline and Postgresql
Next
From: "Marin Dimitrov"
Date:
Subject: Re: text and numeric