[postgis-users] PL/PgSQL and PostGIS

[CYW]

Thank you Michael for all the help.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Michael
Fuhr
Sent: Sunday, June 11, 2006 8:18 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PL/PgSQL and PostGIS

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users