Re: [SQL] spliting a row to make several rows

2006-10-12 Thread Gerardo Herzig
Cool!! Thanks a lot! I will try it as soon as possible Gerardo Gerardo Herzig wrote: Hi all: What a want to do is something like this: suppose i have this record aa--bb--cc I guess if im able to do some sql/plsql procedure to get something like it aa bb cc (3 records, rigth?) Thanks a lo

Re: [SQL] spliting a row to make several rows

2006-10-12 Thread Bricklen Anderson
Gerardo Herzig wrote: Hi all: What a want to do is something like this: suppose i have this record aa--bb--cc I guess if im able to do some sql/plsql procedure to get something like it aa bb cc (3 records, rigth?) Thanks a lot Gerardo dev=#select split_to_rows('aa--bb--cc','--'); split_to_

[SQL] spliting a row to make several rows

2006-10-12 Thread Gerardo Herzig
Hi all: What a want to do is something like this: suppose i have this record aa--bb--cc I guess if im able to do some sql/plsql procedure to get something like it aa bb cc (3 records, rigth?) Thanks a lot Gerardo ---(end of broadcast)--- TIP 9: I