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
