If cannot convert to requested datatype return null

[cwilkes]

I'm inserting rows that have json that I have no control over, so I can get something like this:
{ "a" : { "b" : "c" } }
{ "a" : 100 }
{ "foo": "bar" }
where the "a" value can be another json element, an integer, or not even there. Like in issue #3 where the value is missing it is skipped over can items that cannot be cast to the correct response type be skipped over?

Currently I'm getting "ERROR: wrong json type found string, expected number" which is understandable, but there's no way I can avoid it.

[theirix]

Yes, it is not possible to extract unknown data type without getting an error because in other case you can't distinguish null value from the "wrong" (unexpected) type. Possible solutions:

• to add a bunch of functions that silently return null on unexpected type (not very elegant)
• to add complex type introspection functions (it will require some pgsql code).