Home > mailing lists

Query on JSON field type - Mailing list pgsql-novice

From	Mick
Subject	Query on JSON field type
Date	November 15, 2012 01:49:14
Msg-id	799be782-1492-42bc-a230-4066514dcfee@googlegroups.com Whole thread Raw
Responses	Re: Query on JSON field type
List	pgsql-novice

Hello,
my field is called Samples and the value is {"R":100, "S":101, "Q":102}.  how do I find all Samples for which "R" =
100?
Thank you in advance.

From: "manno_it@libero.it"
Date: 15 November 2012, 00:34:03
Subject: to_number function

From: James David Smith
Date: 15 November 2012, 02:23:14
Subject: Re: to_number function