Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA84116 for ; Fri, 31 Mar 2000 08:00:13 -0500 (EST) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id OAA11795; Fri, 31 Mar 2000 14:59:51 +0200 (CEST) (envelope-from kudo@partitur.se) Message-ID: <38E4A147.9CE24925@partitur.se> Date: Fri, 31 Mar 2000 14:59:51 +0200 From: Patrik Kudo X-Mailer: Mozilla 4.72 [en] (X11; I; FreeBSD 4.0-STABLE i386) X-Accept-Language: en MIME-Version: 1.0 To: Alexander Stetsenko CC: pgsql-sql@postgresql.org Subject: Re: Novice trouble with plpgsql References: <38E498C6.C1D95B2F@anapa.org.ru> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200003/15 try: select max(name_of_column) from name_of_table; Regards, Patrik Kudo Alexander Stetsenko wrote: > > Hello All > Help me please ! > I need to select max value in plpgsql, but > such code seems is not corect: > select into var max(col) from table ; > How can I do this ? > > Thanks you all.