Угу... все проверено - 9,5, все дела. Не выходит аленький цветок
и так
SELECT "raw_storage_basetransaction"."id", "raw_storage_basetransaction"."r_v", "raw_storage_basetransaction"."transaction_data", "raw_storage_basetransaction"."entry_datetime", "raw_storage_basetransaction"."owner_id", ((transaction_data->>'SupplierDB')::int) as "v" FROM "raw_storage_basetransaction" LIMIT 21
и так
SELECT "raw_storage_basetransaction"."id", "raw_storage_basetransaction"."r_v", "raw_storage_basetransaction"."transaction_data", "raw_storage_basetransaction"."entry_datetime", "raw_storage_basetransaction"."owner_id", ("transaction_data" ->> 'SupplierDB') AS "v" FROM "raw_storage_basetransaction" LIMIT 21
и так
SELECT "raw_storage_basetransaction"."id", "raw_storage_basetransaction"."r_v", "raw_storage_basetransaction"."transaction_data", "raw_storage_basetransaction"."entry_datetime", "raw_storage_basetransaction"."owner_id", ("raw_storage_basetransaction"."transaction_data" ->> 'SupplierDB') AS "v" FROM "raw_storage_basetransaction" LIMIT 21
все NULL в V