text and numeric

From: Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: text and numeric
Date: 2002-04-05 09:10:53
Message-ID: 0B87317EA62BD211A02A00A0C9DFB7EC9B5EAE@hermes.bordeaux.cemagref.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marin Dimitrov 2002-04-05 09:35:53 Re: text and numeric
Previous Message Geoff Caplan 2002-04-05 07:48:03 Porting from MySql - meta data issues