Re: pl/pgsql docs 37.4.3. Row Types -- how do I use this

Hello,

Unless your function parameter is an integer you must quote it... eq:

select use_two_tables('tablename');

Sincerely,


Joshua D. Drake


Lee Harr wrote:

> I am following along with the pl/pgsql docs here:
> http://www.postgresql.org/docs/current/static/plpgsql-declarations.html
>
> In section 37.4.3. Row Types I have altered the function slightly
> (I finished the where ... clause) :
>
>
> CREATE or REPLACE FUNCTION use_two_tables(tablename) RETURNS text AS '
> DECLARE
> in_t ALIAS FOR $1;
> use_t table2name%ROWTYPE;
> BEGIN
> SELECT * INTO use_t FROM table2name WHERE f1 = ''a'';
> RETURN in_t.f1 || use_t.f3 || in_t.f5 || use_t.f7;
> END;
> ' LANGUAGE plpgsql;
>
>
>
> Just before that, I created two tables:
>
> CREATE TABLE tablename(
> f1 text,
> f2 text,
> f3 text,
> f4 text,
> f5 text,
> f6 text,
> f7 text
> );
> CREATE TABLE table2name(
> f1 text,
> f2 text,
> f3 text,
> f4 text,
> f5 text,
> f6 text,
> f7 text
> );
>
> and put in some data:
>
> insert into tablename values ('a', 'bb', 'ccc', 'dddd', 'eee', 'ff',
> 'g');
> insert into tablename values ('aa', 'bbb', 'cccc', 'ddd', 'eeee',
> 'fff', 'gg');
> insert into table2name values ('aaaa', 'bbb', 'cc', 'd', 'ee', 'fff',
> 'gggg');
> insert into table2name values ('a', 'bb', 'ccc', 'dddd', 'eeeee',
> 'ffffff', 'ggggggg');
>
>
> Now, how do I call the function?
>
> CREATE FUNCTION
> # select use_two_tables(tablename);
> ERROR: column "tablename" does not exist
> # select use_two_tables(f1);
> ERROR: column "f1" does not exist
> # select use_two_tables(table2name);
> ERROR: column "table2name" does not exist
>
> _________________________________________________________________
> Check out the new MSN 9 Dial-up — fast & reliable Internet access with
> prime features! http://join.msn.com/?pgmarket=en-us&page=dialup/home&ST=1
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL