I know that there's an "average" function (avg) for some datatypes.
Is there something comparable for float or int arrays?
e.g.
select avg(time_instants[1:5]) from ellipse_proc where rep = 1;
time_instants
-
{"148","167.8","187.6","207.4","227
Thanks Darrin and Stuart.
-Tony
Darrin Ladd wrote:
> Here's what you are looking for:
>
> SELECT pg_class.relname
> FROM pg_class, pg_attribute
> WHERE pg_attribute.attname = 'area'
> AND pg_attribute.attrelid = pg_class.oid;
>
> This should give you all of the classes (tables) which have th
I have a database with several tables. I'd like to pull out a list of
names for the tables that contain the field (class) name 'area'.
Can this be done?
-Tony
