Postgres Pro
Downloads
Home   >   mailing lists

Re: "select myfunc(fields) from my table" inside plpgslq proc - Mailing list pgsql-general

From Tom Lane
Subject Re: "select myfunc(fields) from my table" inside plpgslq proc
Date
Msg-id 10106.1015515154@sss.pgh.pa.us
Whole thread Raw
In response to "select myfunc(fields) from my table" inside plpgslq proc  (Jeff Anto <antojf2001@yahoo.fr>)
List pgsql-general
Tree view 
=?iso-8859-1?q?Jeff=20Anto?= <antojf2001@yahoo.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

pgsql-general by date:

Previous
From: Jeff Self
Date:
Subject: Re: Setting up Field constraints
Next
From: Stephan Szabo
Date:
Subject: Re: "select myfunc(fields) from my table" inside plpgslq