[postgis-users] About Invalid OGC WKT Error

strk at refractions.net strk at refractions.net
Fri Feb 4 01:59:30 PST 2005


On Fri, Feb 04, 2005 at 10:43:19AM +0100, Markus Schaber wrote:
(cut)
> > LOG:  statement: SELECT   $1
> > CONTEXT:  PL/pgSQL function "find_srid" line 15 at assignment
> > LOG:  statement: SELECT   $1
> > CONTEXT:  PL/pgSQL function "find_srid" line 16 at assignment
> 
> Two variables are assigned. (I do not know why in the hell this is
> actually implemented using a subquery in plpgsql...)

It's:

	schem = $1;
	tabl = $2;

Would:

	SELECT INTO schem, tabl $1, $2;

perform better and work for all supported pgsql versions ?




More information about the postgis-users mailing list