Re: [SQL] 6

2011-10-14 Thread HAKAN
.The best possible chance to finally kick the deadly habit for good. http://relaxationstation.biz/com.friend.php?igifortune=82a3 -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Tripping over (my own) stupidity - VARCHAR declaration minus specificity

2011-10-14 Thread Good, Thomas
I created a table in a hurry and forgot to specify the max capacity for a varchar() data type. Can it be said what the max would be in a case like this (just curious)? thanks much -- Thomas A. Good, Senior Database Administrator Saint Vincent's Hospital Westchester A Division of Saint Joseph's M

Re: [SQL] Tripping over (my own) stupidity - VARCHAR declaration minus specificity

2011-10-14 Thread Adam Cornett
On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas wrote: > I created a table in a hurry and forgot to specify the max capacity for a > varchar() data type. > Can it be said what the max would be in a case like this (just curious)? > > thanks much > > -- > Thomas A. Good, Senior Database Administrator

Re: [SQL] Tripping over (my own) stupidity - VARCHAR declaration minus specificity

2011-10-14 Thread [email protected]
On Fri, Oct 14, 2011 at 01:51:04PM -0400, Adam Cornett wrote: > On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas wrote: > > > I created a table in a hurry and forgot to specify the max capacity for a > > varchar() data type. > > Can it be said what the max would be in a case like this (just curious)

Re: [SQL] Tripping over (my own) stupidity - VARCHAR declaration minus specificity

2011-10-14 Thread Adam Cornett
On Fri, Oct 14, 2011 at 2:09 PM, [email protected] wrote: > On Fri, Oct 14, 2011 at 01:51:04PM -0400, Adam Cornett wrote: > > On Fri, Oct 14, 2011 at 1:27 PM, Good, Thomas wrote: > > > > > I created a table in a hurry and forgot to specify the max capacity for > a > > > varchar() data type. > > > Ca

Re: [SQL] Tripping over (my own) stupidity - VARCHAR declaration minus specificity

2011-10-14 Thread Good, Thomas
Thanks guys - yes Adam it seems to behave exactly like text, at least in my experience. From: Adam Cornett [[email protected]] Sent: Friday, October 14, 2011 2:24 PM To: [email protected] Cc: Good, Thomas; [email protected] Subject: Re: [SQL] Trippi