DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=Ez41j1u2eYFUwvFdmP2xiGqe7Snvs39XW3jEZgRsxaNq/c/5Leg/UxB0NcRhwgm3Zh
	vtzpJBOfd1E6pgQNiy6Ng8EQzl+x2CmwvOnP77qLRF9cZbDNrI7rO8Zo/t2IkYm4eFLZ
	PorSD1XBw6hEm+70GQR9SoB0JS0QL0S16zYhQ=
MIME-Version: 1.0
In-Reply-To: <201004091018.37965.johnf@jfcomputer.com>
References: <201004091018.37965.johnf@jfcomputer.com>
Date: Fri, 9 Apr 2010 19:32:51 +0200
Message-ID: <k2z162867791004091032r401ee913r3531742cb8c2871@mail.gmail.com>
Subject: Re: understanding select into
From: Pavel Stehule <pavel.stehule@gmail.com>
To: John <johnf@jfcomputer.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello

2010/4/9 John <johnf@jfcomputer.com>:
> Hi,
> I am reviewing a function written by some xTuple guys. =C2=A0What is inte=
resting
> about it is it uses the "INTO" statement like
>
> select something into _p from sometable where somecriteria.
>
> The function contiunes and uses the data retreived
> _p.somefield_name
>
> And then the function ends.
>
>
> Ok my question:
>
> I also thought the select "into" created a real table. =C2=A0But after ru=
nning the
> function the table does not exist. =C2=A0I see no where that a 'drop' is =
issued.
> In fact the function uses lot's of select into's like (_test, _r, etc..).=
 =C2=A0So
> would some kind soul explain what is happening.
>

_p is record variable. See some lines before. There will be DECLARE part

DECLARE p RECORD;

There is plpgsql's SELECT INTO and SQL's SELECT INTO with little bit
different syntax. First - target is list of variables or record
variable, second - target is table.

> Could it be that "_p" is drop automaticly when the function ends? =C2=A0S=
omething
> to do with scope.
>

_p is just variable

regards
Pavel Stehule

> Could it have something to do with the fact the function returns only an
> integer? =C2=A0And that causes the table to be drop.
>
> As you can see I'm lost here!
>
>
> Johnf
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>