Skip site navigation (1) Skip section navigation (2)

From: "SANDEEP CHIBBER" <sandeepchibber(at)hotmail(dot)com>
To: pgsql-ports(at)postgresql(dot)org
Subject:
Date: 2002-05-24 10:46:21
Message-ID: F32fRfTSNtm4trpzyn30000c1bb@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-ports
Your name  : Sandeep Chibber
Your email address : sandeep(at)vreach(dot)net


System Configuration
---------------------
  Architecture (example: Intel Pentium)   : Intel Pentium

  Operating System (example: Linux 2.0.26 ELF)  : Windows 2000 Professional

  PostgreSQL version (example: PostgreSQL-7.2.1):   PostgreSQL-7.2.1

  Compiler used (example:  gcc 2.95.2)  :


Please enter a FULL description of your problem:
------------------------------------------------
We have create a function which will retreive all columns along with the 
multiple rows of data.
Only one Column is displayed and it has an id not the data.
If there are more than one rows then same id will be repeated as many 
times.Even if there is one row only a single id column is displayed




Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Table structure

create table nodes (name varchar(50),parent varchar (50))

CREATE FUNCTION listchildren2(text) RETURNS SETOF nodes AS
'SELECT name ,parent FROM nodes WHERE parent > $1;'
LANGUAGE 'SQL';


select listchildren2('0')




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Sorry no ideas

Thanks

Sandeep Chibber




_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


pgsql-ports by date

Next:From: vadimDate: 2002-05-27 18:41:52
Subject: A WinXP patch
Previous:From: Tegge, BerndDate: 2002-05-07 14:13:38
Subject: Re: qnx port

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group