Ramesh T wrote
> Hi,
> when i ran below statement its working fine..
> select string_agg(part_id::text,':') from part;
> But,
> SELECT tab_to_largeStringcheck(cast(string_agg(part_id::text,':')as
> t_varchar2_tab)) FROM part
>
>
> [image: Inline image 1]
>
> when i ran like
>
> SELECT
> qa.tab_to_largeStringcheck(string_agg(part_id::text,':'))
> FROM qa.part
> its returnfunction( text)does'nt exist
> let me know how solve issue..
> thanks,
You really need to spend a day reading the PostgreSQL documentation,
especially the parts on what functions and data types are available. There
are many things that work in Oracle but not PostgreSQL simply because names
are different. If you know what need to do you should be able to recognize
the stuff in PostgreSQL that will accomplish the same goal. You may have to
write custom functions too.
You should also explore EDB and the Oracle compatibility stuff they have
written.
Note that "tabtolargestringcheck(text)" is not a known PostgreSQL
function...
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/tab-to-sting-tp5812613p5813223.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.