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

From: "SANDEEP CHIBBER" <sandeepchibber(at)hotmail(dot)com>
To: pgsql-ports(at)postgresql(dot)org
Date: 2002-05-24 10:46:21
Message-ID: (view raw, whole thread or download thread mbox)
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;'

select listchildren2('0')

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


Sandeep Chibber

Join the worlds largest e-mail service with MSN Hotmail.

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-2017 The PostgreSQL Global Development Group