Skip to content

Instantly share code, notes, and snippets.

@otobrglez

otobrglez/casting_types.rb

Created March 12, 2015 10:55
Show Gist options
  • Star 5 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save otobrglez/6bc6c4f1c27abb8d1f53 to your computer and use it in GitHub Desktop.
Save otobrglez/6bc6c4f1c27abb8d1f53 to your computer and use it in GitHub Desktop.
Download ZIP
unknown OID 705: failed to recognize type of '<field>'. It will be treated as String.
Raw
casting_types.rb
#!/usr/bin/env ruby
# If you get "unknown OID 705: failed to recognize type of '<field>'. It will be treated as String."
# it probably means that type of column could not be identified when retriving records
# Example
User.where("'something' as something")
# Will results in unknown OID. However doing this:
User.where("'something'::text as something")
# Will just work. Casting is important, dude!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment