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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
