...

Your name  : Sandeep Chibber
Your email address : sandeep@vreach.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 world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com