Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: operator va...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 21 Topic 15458 of 17602
Post > Topic >>

Re: operator varchar = integer

by Daniel Schuchardt <daniel_schuchardt@[EMAIL PROTECTED] > May 5, 2008 at 06:53 PM

>
> No buts.  If you create those automated casts, you are just putting
> off the inevitable.
>   
yes but than it will become a future project. (i think with postgres 8,5 
or 8,6 :-P )
>
> You're just confirming the fact that your project is in existential
> trouble.
>   
no, we would get trouble if we upgrade. now everybody is happy :-).
btw: our first software release was with postgres 7.3 and since this 
time we use this feature (about 6 years?).
> How do you know?  8.3 removed the implicit casts precisely because
> they were producing results that could most generously be describe as
> "surprising."
>   
yeah thats an old discussion. we know about this and so we look for it. 
it is a powerfull feature in 81 (and earlier) and yes if you use it in 
the wrong way it will produce "surprising" results but if you use it in 
the right way it is very powerfull. and if we get a suprising behavoir 
we do in an explicit cast. done. ;-)
> Cheers,
> David.
>   

daniel.
 




 21 Posts in Topic:
operator varchar = integer
Daniel Schuchardt <dan  2008-05-05 11:18:37 
Re: operator varchar = integer
Daniel Schuchardt <dan  2008-05-05 12:55:25 
Re: operator varchar = integer
laurenz.albe@[EMAIL PROTE  2008-05-05 14:44:02 
Re: operator varchar = integer
david@[EMAIL PROTECTED]   2008-05-05 07:33:30 
Re: operator varchar = integer
Daniel Schuchardt <dan  2008-05-05 17:26:40 
Re: operator varchar = integer
david@[EMAIL PROTECTED]   2008-05-05 08:52:54 
Re: operator varchar = integer
Daniel Schuchardt <dan  2008-05-05 18:53:20 
Re: operator varchar = integer
tgl@[EMAIL PROTECTED] (T  2008-05-05 13:36:01 
Re: operator varchar = integer
Daniel Schuchardt <dan  2008-05-05 21:04:41 
Re: operator varchar = integer
Daniel Schuchardt <dan  2008-05-05 18:32:37 
operator is not unique: integer || integer
Daniel Schuchardt <dan  2008-05-05 18:43:37 
Re: operator is not unique: integer || integer
Daniel Schuchardt <dan  2008-05-05 20:54:07 
Re: operator is not unique: integer || integer
daniel_schuchardt@[EMAIL   2008-05-05 21:36:51 
Re: operator is not unique: integer || integer
kgore4@[EMAIL PROTECTED]   2008-05-06 10:05:18 
Re: operator is not unique: integer || integer
Daniel Schuchardt <dan  2008-05-06 10:08:06 
Re: operator is not unique: integer || integer
dalroi@[EMAIL PROTECTED]   2008-05-06 08:36:46 
Re: operator is not unique: integer || integer
Daniel Schuchardt <dan  2008-05-06 10:33:37 
now i'm really confused. insert/update does autocast, where some
Daniel Schuchardt <dan  2008-05-06 11:31:55 
Re: now i'm really confused. insert/update does autocast, where
Daniel Schuchardt <dan  2008-05-06 11:56:17 
Re: now i'm really confused. insert/update does autocast, where
kleptog@[EMAIL PROTECTED]  2008-05-06 13:16:30 
Re: now i'm really confused. insert/update does autocast, where
peter_e@[EMAIL PROTECTED]  2008-05-08 17:26:17 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:26:50 CST 2008.