Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id A486243CEB8
	for <pgsql-sql@postgresql.org>; Thu, 19 Jan 2012 05:57:23 -0400 (AST)
Received: from nm10-vm2.bullet.mail.ne1.yahoo.com ([98.138.90.158])
	by magus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <pk_rehan@yahoo.com>) id 1RnokE-0004dF-Aa
	for pgsql-sql@postgresql.org; Thu, 19 Jan 2012 09:57:23 +0000
Received: from [98.138.90.56] by nm10.bullet.mail.ne1.yahoo.com with NNFMP;
	19 Jan 2012 09:57:09 -0000
Received: from [98.138.89.160] by tm9.bullet.mail.ne1.yahoo.com with NNFMP;
	19 Jan 2012 09:57:09 -0000
Received: from [127.0.0.1] by omp1016.mail.ne1.yahoo.com with NNFMP;
	19 Jan 2012 09:57:09 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 280056.84637.bm@omp1016.mail.ne1.yahoo.com
Received: (qmail 16354 invoked by uid 60001); 19 Jan 2012 09:57:09 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1326967029; bh=2j/9RJAV/UCQrrb47SYwxnlDQLTgrJyNzRRimRFpPJU=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=gUfRfBoaGhq9CWv3sHm/HB+Kdz9KiPnmz/yK2uWQIQC4knIVFeYmlCgcmw2rfRxWJVWbYoUgqshjC+V+LLn9hbUn1LaikUDgBMJjGx6GY/Bn3HAiu3H6kDuD11pynsA5LVca2oA27z9sMYR8cJYXBkXwRrLJZLSZGr9rOMINisg=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=3vdWzsiBQ+fCaGFYO86n9O5ZhvK+T84Mmv8FOmUxQPmTnN62AJLC++UgT8k9mDC3hzTJG571mZ9jR8fKQb1CCoxUttpBnOFKxSXw5PRetjvqcHS/B1WZZ4sPGaSwzOHlDPd6yHZSrj8iEYLkMgerkatfEMZf0hXmKZqEuhUnpKw=;
X-YMail-OSG: C3IPqFQVM1mE7WgAzlMem5RgfDWSdWKsCbcp8ZlcrnufHiV
	RLorq1UklI3pJW7waVa2igSjqi7HOtpFxMYAa1NLamq7IaloEcDfIGG0Tk6F
	_0Yh68Ua7fDXOEFN0dgNWp58JyVFoPKVcukMPnVFrB4Jv_i0UCKuKDBvyGe5
	W_HuW_urNqmlIuqVudthdgMIgw9lHjYbNWB_J282UmTl59fbZnhkfF_d6Oy9
	x1kTNtQYEsqa5Qm0go8sBf4HhV6HUbQRSeDhw.62SUK07PU.f1aFLXGbEekT
	DGxVGY3kl2dra6Jo98sWsF6FwD.Owj4be4Wz2quR272XMzjoIm3xX3m_gjaz
	f.GmlWleUXd1WwDix9x601gPIP374pywcw9PHuhF2Fxeimq.4_2H5fi9wkCX
	qJK4zssx1HbGD1T_QJ76VzbICGSfLBsih1VirByHxnSWc_InrkUfvc5Ww0AC
	JOpDcoupBCkXUcsLmYmkDdd0lyQ--
Received: from [180.178.150.115] by web121601.mail.ne1.yahoo.com via HTTP;
	Thu, 19 Jan 2012 01:57:09 PST
X-Mailer: YahooMailWebService/0.8.115.331698
Message-ID: <1326967029.84665.YahooMailNeo@web121601.mail.ne1.yahoo.com>
Date: Thu, 19 Jan 2012 01:57:09 -0800 (PST)
From: Rehan Saleem <pk_rehan@yahoo.com>
Reply-To: Rehan Saleem <pk_rehan@yahoo.com>
Subject: how to return whole table from Function not just the id integer
 column
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="-1977980688-29967351-1326967029=:84665"
X-Pg-Spam-Score: -2.0 (--)
X-Archive-Number: 201201/86
X-Sequence-Number: 36257

---1977980688-29967351-1326967029=:84665
Content-Type: text/plain; charset=us-ascii

hi ,
how can i return the whole user table from this function not just the id . thanks
CREATE TABLE users(id serial PRIMARY KEY, first_name varchar(10), last_name
varchar(10)); CREATE OR REPLACE FUNCTION new_user(fname varchar, lname varchar)
RETURNS int AS $$
DECLARE r int;
BEGIN -- custom exception -- lname cannot be empty or NEMO IF trim(lname) = '' OR lower(lname) = 'nemo' THEN RAISE EXCEPTION 'bad last_name: "%"', lname; END IF; INSERT INTO users(first_name, last_name) VALUES(lname, fname) RETURNING
id INTO r; RETURN r;
END;
$$ LANGUAGE plpgsql;
---1977980688-29967351-1326967029=:84665
Content-Type: text/html; charset=us-ascii

<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><pre style="font-size: 11px; word-wrap: break-word; text-align: left; ">hi ,</pre><pre style="font-size: 11px; word-wrap: break-word; text-align: left; ">how can i return the whole user table from this function not just the id . thanks</pre><pre style="font-size: 11px; word-wrap: break-word; text-align: left; ">CREATE TABLE users(id serial PRIMARY KEY, first_name varchar(10), last_name
varchar(10));

CREATE OR REPLACE FUNCTION new_user(fname varchar, lname varchar)
RETURNS int AS $$
DECLARE r int;
BEGIN
  -- custom exception -- lname cannot be empty or NEMO
  IF trim(lname) = '' OR lower(lname) = 'nemo' THEN
    RAISE EXCEPTION 'bad last_name: "%"', lname;
  END IF;
  INSERT INTO users(first_name, last_name) VALUES(lname, fname) RETURNING
id INTO r;
  RETURN r;
END;
$$ LANGUAGE plpgsql;</pre></div></div></body></html>
---1977980688-29967351-1326967029=:84665--