question about PL/pgSQL function - Mailing list pgsql-sql

From datactrl
Subject question about PL/pgSQL function
Date
Msg-id 000901c0e9c4$4bd843a0$2400a8c0@hnjack
Whole thread Raw
Responses Re: question about PL/pgSQL function  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
With postgres 7.1
1. Function like example found on 24.4 Example in Programmer Guide   CREATE FUNCTION xxx (EMP, integer) RETURNS boolean
AS'......  (which EMP is a table )   How do I pass a record to this function in PL/PGSQL? I try this
 
....   select into rec1 * from EMP where empNo =''xxxx'';   i1 :=  xxx(rec1,5);
....   But it won't work!
2. Is that possible to return a record from a function? And how do I get the
returned record in PL/pgSql

JACK



pgsql-sql by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: SELECT * INTO TABLE is not working for me.
Next
From: Brian Powell
Date:
Subject: 7.1.1 Lock Problems on Views