Re: pl/pgsql docs 37.4.3. Row Types -- how do I use this function? - Mailing list pgsql-general

From Tom Lane
Subject Re: pl/pgsql docs 37.4.3. Row Types -- how do I use this function?
Date
Msg-id 4342.1074974144@sss.pgh.pa.us
Whole thread Raw
In response to pl/pgsql docs 37.4.3. Row Types -- how do I use this function?  ("Lee Harr" <missive@hotmail.com>)
List pgsql-general
"Lee Harr" <missive@hotmail.com> writes:
> I am following along with the pl/pgsql docs here:
> http://www.postgresql.org/docs/current/static/plpgsql-declarations.html

> Now, how do I call the function?

I believe you want

select use_two_tables(tablename.*) from tablename;

"foo.*" is the locution for referring to the whole-row value coming from
table foo in a select.

            regards, tom lane

pgsql-general by date:

Previous
From: Eric B.Ridge
Date:
Subject: Re: Touch row ?
Next
From: Eric Ridge
Date:
Subject: Re: Touch row ?