On Thu, 2001-09-27 at 10:09, roypgsqlphp@xxxxxxxxxx wrote: > Can anyone tell me what the maximum length of a varchar returned from a plpgsql function is? > It depends on your version of PostgreSQL, but it should be of the order of 100's of MB with current versions. Using LZTEXT type with 7.0 I was retrieving fields up to around 100-200k (depending on compressibility), but 7.1 implements automatic offloading/compressing of large fields. I don't believe there should be current limitations in the implementation of pl/pgsql which would impose lower limits on these things than are imposed by the database field types. Someone will no doubt correct me if I am wrong :-) Regards, Andrew. -- -------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7217 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
