SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 10:14 AM
| ||||
| ||||
 BUG #2643: Auto trim on insert and update The following bug has been logged online: Bug reference: 2643 Logged by: Gene Neely Email address: paul.neely@comcast.net PostgreSQL version: 8.0.x 8.1.x Operating system: Linux Description: Auto trim on insert and update Details: THIS IS NOT A BUG, but a request. Found no place else to submit. I have found no way to automatically trim fields to the length of the varchar or char on inserts and updates. I have tried to create check rules to trim to the varchar length with not luck. Can this become a Configuration option??? Doing trims of every variable at every sql command execution takes a lot of time both coding and lookup the columns length. Thanks. Gene Neely ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-10-2008, 10:14 AM
| ||||
| ||||
| Re: BUG #2643: Auto trim on insert and update "Gene Neely" <paul.neely@comcast.net> writes: > I have found no way to automatically trim fields to the length of the > varchar or char on inserts and updates. Write an explicit cast to varchar(N) or whatever it is. > Can this become a Configuration option??? No, because the behavior is required by the SQL standard. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
