New question:
i have tables like
table_20041124,
table_20041125,
etc...
i'm trying to make function (for example):
=====================================
CREATE FUNCTION get_count(text, text)
RETURNS int2 AS '
DECLARE
cnt int4;
BEGIN
SELECT INTO cnt COUNT(*)
FROM table_$1 -- That doesn't work
WHERE key = $2;
RETURN cnt;
END;'
LANGUAGE 'plpgsql';
=====================================
call this function by:
=====================================
SELECT get_count("20041124", "something");
=====================================
string in funstion - FROM table_$1
how could i get a final correct table name here?
Thanx!
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
