concatenate strings

[teroy]

Hi there,
if i have a query which is the following:
select '<option value=' || id || '>' || name as hehe from library;

which produces the result
hehe
------------------------------------------------------
<option value=1>Bayside City Council Library Service


How can i make it concatenate every record which is in that table and return it as one field?

Is there a standard function for something like this or has anyone written something similiar?

Thanks in Advance


troy

 

[RahulGade]

You can use any delimeter to seperate that records, Just for example what i have used is ; (semicolon) as a delimiter for records, and you can extract the records using front end login by looking for semicolons, or if you wish to store semicolon as a part of record then you may choose any special charector or extended ascii charectors for that, through front end.

 

[teroy]

sorry i didn't make myself clear
if i had in the database

id | url
----+-------------------------------
1 |

http://www.bayside.vic.gov.au

2 |

http://www.vicnet.net.au

i would do
select '<option value=' || id || '>' || name as hehe from library;

which produces the result
hehe
------------------------------------------------------
<option value=1>

http://www.bayside.vic.gov.au

<option value=2>

http://www.vicnet.net.au

which returns 2 records. What i'm looking for is a way to make it so it returns the whole thing in one field. Therefore when i use my scripting language (perl) i can just fetch the one record which would have all the data in it. I hope this makes more sense..

cheers

troy

 

[RahulGade]

Then for the multiple records value, you should choose temp tables, You should select all the records in to one temp table using &quot;create temp table tmptable as select * from table&quot;
then select the records using &quot;select * from tmptable&quot;
this will solve your problem.



Rahul Gade
( Concretio India Pvt.Ltd., Nagpur, India)

 

[teroy]

thankyou Rahul