Postgres Pro
Downloads
Home   >   mailing lists

Table column with numeric and string values - Mailing list pgsql-admin

From Firthouse banu
Subject Table column with numeric and string values
Date
Msg-id CAK_Ha4yB_gr7ugb1Xy70y_QvazXz55_fYxvRxzSaneAVSqEUOA@mail.gmail.com
Whole thread Raw
Responses Re: Table column with numeric and string values
List pgsql-admin
Tree view
Hello everyone, 

Need a urgent help.

I have a table sqlt_data with column strungvalue  as character varying , in that column we have both numbers and string. 
I have function which pulls this values and do round(avg(string value::numeric,2),0) . Am able to run the function fine with numeric values and it is obvious but for string values getting error. How to make this function work with string values . As far as I know avg or round cannot be done on string values. Please advise.

Thanks
Firthouse 

pgsql-admin by date:

Previous
From: liam saffioti
Date:
Subject: Re: autoovacuum launcher process
Next
From: soumitra bhandary
Date:
Subject: Re: Table column with numeric and string values