Re: "select myfunc(fields) from my table" inside plpgslq proc

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Anto <antojf2001(at)yahoo(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "select myfunc(fields) from my table" inside plpgslq proc
Date: 2002-03-07 15:32:34
Message-ID: 10106.1015515154@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-1?q?Jeff=20Anto?= <antojf2001(at)yahoo(dot)fr> writes:
> It seems that semantic of
> select INTO var myfunc(...) from ... are different in
> plpgsql program than pure sql
> select myfunc(...) from ...

Yup. See the docs, eg
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/plpgsql-statements.html#PLPGSQL-SELECT-INTO

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-03-07 15:38:20 Re: Migration problem - serial fields
Previous Message Stephan Szabo 2002-03-07 15:30:27 Re: "select myfunc(fields) from my table" inside plpgslq