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 (pgsql-sql@postgresql.org) 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 k...@rice.edu
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, k...@rice.edu 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 [adam.corn...@gmail.com] Sent: Friday, October 14, 2011 2:24 PM To: k...@rice.edu Cc: Good, Thomas; pgsql-sql@postgresql.org Subject: Re: [SQL] Trippi