Re: [GENERAL] Table name as parameter in function

ynamically. See: http://www.postgresql.org/docs/7.4/interactive/plpgsql- statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN On Nov 23, 2004, at 2:56 PM, Alexander Pucher wrote: Hi, struggling around with this for some time: How can I use a table name as a parameter in a PL/pgSQL function ?? I tr

[GENERAL] Table name as parameter in function

Hi, struggling around with this for some time: How can I use a table name as a parameter in a PL/pgSQL function ?? I tried this but it didn't work... CREATE OR REPLACE FUNCTION my_row_count(text) RETURNS int4 AS ' DECLARE num_rows int4; BEGIN num_rows := (select count(*) from $1); RETURN n

[GENERAL] Mathematical operations with NULL values

Hi, given a table with some data, e.g. some monthly measures. Some of the measures are missing though. id   m1   m2   m3   m4   m5      m12 -- 1    23    45    66    76    76        12  2    76    NULL    77   88   77   ...    89 3    67