FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedMay 24, '02 at 10:46a
activeMay 24, '02 at 10:46a
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

SANDEEP CHIBBER: 1 post

People

Translate

site design / logo © 2022 Grokbase