Re: query ... returned 4 columns - Mailing list pgsql-general

Sorin Schwimmer wrote:
> Hi All,
>
> I'm trying to write a stored PLPG/SQL procedure:

>     o:= * FROM expected_stuff WHERE packslip=$1; --
> LIMIT 1;

Is this valid syntax? I'm a little surprised, but I think I can see
what's happening.

Try something more like:
   SELECT * INTO o FROM expected_stuff...

See if that makes a difference
--
   Richard Huxton
   Archonet Ltd