We help IT Professionals succeed at work.

using select in postgresql function

danafire
danafire asked
on
Medium Priority
1,438 Views
Last Modified: 2012-05-06
how can i use select statement in postgresql function. When i place a select in, i get the error:

ERROR:  query has no destination for result data
HINT:  If you want to discard the results of a SELECT, use PERFORM instead.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
say table x has columns id and coly

create or replace function xx( arg1 int ) returns void as $$
declare
  x tablex.coly%TYPE;
begin
  select coly into x  from tablex where id = arg1;
end;
$$ language plpgsql;

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.