Postgres Pro
Downloads
Home   >   mailing lists

Re: return %ROWTYPE from function - Mailing list pgsql-sql

From jr
Subject Re: return %ROWTYPE from function
Date
Msg-id htck01$15od$1@news.hub.org
Whole thread Raw
In response to return %ROWTYPE from function  (Anton Prokofiev <a.d.prokofiev@googlemail.com>)
List pgsql-sql
Tree view 
hi Anton,

works fine if you write:

create or replace function get_rec (in p_id test.id%TYPE) returns test as $$

-- 

regards, jr.  (jr@tailorware.org.uk)

pgsql-sql by date:

Previous
From: Anton Prokofiev
Date:
Subject: return %ROWTYPE from function
Next
From: jr
Date:
Subject: Re: safely exchanging primary keys?