From: John <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org
Subject: Re: understanding select into
Date: Fri, 9 Apr 2010 10:53:48 -0700
User-Agent: KMail/1.9.9
References: <201004091018.37965.johnf@jfcomputer.com>
	<k2z162867791004091032r401ee913r3531742cb8c2871@mail.gmail.com>
In-Reply-To: <k2z162867791004091032r401ee913r3531742cb8c2871@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201004091053.48604.johnf@jfcomputer.com>

Wow thanks to all that replied - you folks are correct.  The "_p" and the=20
others are vars.
_p RECORD;

I won't forget that one for a long time (however, I do drink :-))

Johnf
On Friday 09 April 2010 10:32:51 am Pavel Stehule wrote:
> Hello
>
> 2010/4/9 John <johnf@jfcomputer.com>:
> > Hi,
> > I am reviewing a function written by some xTuple guys. =C2=A0What is
> > interesting 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 =
running
> > the function the table does not exist. =C2=A0I see no where that a 'dro=
p' 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=A0Something 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