[postgis-users] About Invalid OGC WKT Error

[Markus Schaber]

Hi, strk,

strk at refractions.net schrieb:

>>>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;

I did not think that there are subqueries in the source, I only wondered
why plpgsql internally uses subqueries for such simple variable assignments.

> Would:
>
> 	SELECT INTO schem, tabl $1, $2;
>
> perform better and work for all supported pgsql versions ?

I have no idea, sorry.

Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050204/879d4303/attachment.pgp>