[postgis-users] PL/PgSQL and PostGIS

[Michael Fuhr]

On Sat, Jun 10, 2006 at 02:34:39PM -0500, CYW wrote:
> The point_table is in fact like (integer,.. geometry). 
> 
> Is it true that I can not use ROWTYPE if I have a Geometry column? I
> actually need to get all columns.  I need to read the document about Record.

If you use ROWTYPE then the columns you select must match that row
type.  You can select fewer columns than the ROWTYPE has, in which
case the extras will be assigned NULL, but the columns you do select
must be convertible to the types of the ROWTYPE's leading columns.

-- 
Michael Fuhr