"Josh Berkus" <[EMAIL PROTECTED]> writes:
> That's because the SELECT INTO variable and SELECT INTO record syntax
> are confusingly different. It's
> for records:
> SELECT INTO record_var * FROM ...
> for simple variables:
> SELECT column INTO variable FROM ...
> I'm not clear on the origin of
Tom,
> No, this isn't right. If you check the source code you will discover
> that plpgsql is extremely lax about the positioning of the INTO
> clause,
> and will in fact accept it almost anywhere. Datatype has nothing to
> do with this. (It probably should be stricter, but at this point I
> d
Morgan,
> One other problem I am having in that proc is SELECT'ing INTO a var.
>
> declare
> id lookup_sports.sport_id%TYPE;
> begin
> SELECT INTO id sport_id FROM lookup_sports WHEREsome
> clause
>
> id is always null
That's because the SELECT INTO variable and SELECT IN
