From: | des(at)des(dot)no (=?iso-8859-1?q?Dag-Erling_Sm=F8rgrav?=) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | tablename type? |
Date: | 2004-07-27 18:55:39 |
Message-ID: | xzpk6wpuvo4.fsf@dwp.des.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The PL/PGSQL documentation contains at least two examples of functions
which take an argument of type "tablename", which then serves as a
table name in a query. Here's one of those examples:
> CREATE FUNCTION concat_selected_fields(tablename) RETURNS text AS '
> DECLARE
> in_t ALIAS FOR $1;
> BEGIN
> RETURN in_t.f1 || in_t.f3 || in_t.f5 || in_t.f7;
> END;
> ' LANGUAGE plpgsql;
Typing this at the psql prompt, however, simply results in the
following message:
ERROR: type tablename does not exist
Is the documentation incorrect, or is there something wrong with my
PostgreSQL 7.4.3 installation?
If the documentation is incorrect, is there another way to achieve
this, or do I have to use a varchar argument and construct and execute
a dynamic command?
DES
--
Dag-Erling Smørgrav - des(at)des(dot)no
From | Date | Subject | |
---|---|---|---|
Next Message | Arguile | 2004-07-27 20:36:48 | Re: Trigger on Postgres for tables syncronization |
Previous Message | Prabu Subroto | 2004-07-27 17:16:11 | altering a table to set serial function |