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