On Thu, 2001-09-27 at 10:09, roypgsqlphp@xemaps.com 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