[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] query ... returned 4 columns
From:       Richard Huxton <dev () archonet ! com>
Date:       2007-03-08 16:07:32
Message-ID: 45F034C4.70304 () archonet ! com
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]