Re: Table name lengths...

From: Chris Bowlby <excalibur(at)hub(dot)org>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table name lengths...
Date: 2003-09-02 18:08:58
Message-ID: 1062526135.97203.35.camel@morpheus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2003-09-02 at 14:46, Alvaro Herrera wrote:

> Cast a long string to the name type and measure its length:
>
> test=> SELECT length(repeat('xyzzy', 100)::name);
> length
> --------
> 63
> (1 row)

Cool, thanks that will work fairly well..

--
Chris Bowlby <excalibur(at)hub(dot)org>
Hub.Org Networking Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jenny - 2003-09-02 18:56:42 Re: identifying each individual tuple locked
Previous Message Jeffrey Melloy 2003-09-02 18:08:45 Re: segfaults / backend crashing