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