Re: Where is the char and varchar length in pg_catalog for function input variables - Mailing list pgsql-general

From jam3
Subject Re: Where is the char and varchar length in pg_catalog for function input variables
Date
Msg-id 1346862356693-5722850.post@n5.nabble.com
Whole thread Raw
In response to Re: Where is the char and varchar length in pg_catalog for function input variables  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-general
Yeah thats what I was starting to wonder if those lengths basically mean
nothing. I am writing a ton of functions to unit test all of the functions
in our app and am generating random strings and would like to pass the
lengths to my random string generator so if it's varchar 50 I am generating
a string between 0 and 50 length but since I can't find the length value I
guess I am just going to put an arbitrary length in.

Would be nice to know what exactly is going on when you have a length
specified on an input variable in pg_catalog.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Where-is-the-char-and-varchar-length-in-pg-catalog-for-function-input-variables-tp5722845p5722850.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres process got stuck in "notify interrupt waiting" status
Next
From: "Sahagian, David"
Date:
Subject: values from txid_current()