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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
